Re: create table as select

Bulbultyagi,
You can also consider to use a tool called OraExp from http://www.agileinfosoftware.com

It uses OCI to read long, blob, clob etc and generate insert statements as a SQL script and then you can run this script to load it to your target database, export is pretty fast. I tried the other day and it worked great.

Eric
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, December 07, 2003 12:04

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Eric King
  INET: erickingus_at_hotmail.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).