RE: CTAS and ora-1723

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Thu, 1 Jul 2004 21:21:05 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNEEGNCFAA.lex.de.haan@naturaljoin.nl>

From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl] Sent: Thursday, July 01, 2004 20:08
To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Sent: Thursday, July 01, 2004 20:04
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jul 01 2004 - 14:28:33 CDT