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.
[EMAIL PROTECTED]
-----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: <[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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
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).
