RE: CTAS and ora-1723
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Jul 2004 21:21:05 +0200
From: Lex de Haan [mailto:lex.de.haan@xxxxxxxxxxxxxx]
Sent: Thursday, July 01, 2004 20:08
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: CTAS and ora-1723
I think Oracle is not able to derive a datatype from the query
for those columns where you just specify NULL,
and you are creating a table ...
Kind regards,
Lex.
---------------------------------------------
visit my website at http://www.naturaljoin.nl
---------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David
Sent: Thursday, July 01, 2004 20:04
To: oracle-l@xxxxxxxxxxxxx
Subject: CTAS and ora-1723
Any ideas on why this would error out? Is it the nulls?
create table tsteil.sub_duration_duration as (
select NULL provider, a.user_id, a.subscription_id, a.game_code,
...
-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-vcard
-- File: Lex de Haan.vcf
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
