RE: create table as select

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Sun, 07 Dec 2003 09:04:24 -0800
Message-ID: <F001.005D91DA.20031207090424@fatcity.com>

Bulbultyagi

   My recollection is that with a LONG datatype you cannot use a create table as select, but must use the COPY command. I cannot confirm whether COPY is available in 10g. Sorry.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Sunday, December 07, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L

List , I am using Oracle 9.2.0.1.0 enterprise edn on windows.

I have a table with a long datatype column. Is there any way of duplicating this table using the "create table ... as select" command ? or do I have to use the copy command ? Is the copy command present in 10g ?

> desc s_warehouse

Name                                      Null?    Type
 --------------                             --------   ----------

.....
....

 ADDRESS                                            LONG

....

> create table test as select * from s_warehouse ;
create table test as select * from s_warehouse

                            *

ERROR at line 1:
ORA-00997: illegal use of LONG datatype

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sun Dec 07 2003 - 11:04:24 CST