create table as select

From: <bulbultyagi_at_now-india.net.in>
Date: Sun, 07 Dec 2003 06:04:25 -0800
Message-ID: <F001.005D91D7.20031207060425@fatcity.com>

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).

Received on Sun Dec 07 2003 - 08:04:25 CST