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: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
