Copy table and data to new table with a LONG RAW field

I want to copy a table containing a LONG RAW field

the following doesn't work

CREATE TABLE DATA_BACKUP
AS
SELECT * FROM DATA

any ideas ?
LVL 38
Geert GruwezOracle dbaAsked:
Who is Participating?
 
paquicubaConnect With a Mentor Commented:
SQL*Plus Copy utility:

SQL> CREATE TABLE TEST( LONG_RAW_COL LONG RAW);

Table created.

Elapsed: 00:00:00.10
SQL> copy from <User>/<password>@<database> to <User>/<password>@<database> create new_test using select * from test;

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
Table NEW_TEST created.

   0 rows selected from <User@<database>.
   0 rows inserted into NEW_TEST.
   0 rows committed into NEW_TEST at <User@<database>..

SQL>
0
 
Geert GruwezOracle dbaAuthor Commented:
ok but how to do it from a script
with something like TOAD
0
 
sujith80Connect With a Mentor Commented:
In TOAD(I am using version 9)

You have to use - Execute As a Script

Choose the option - Execute in sqlplus , by clicking the small drop down next to the script icon.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Geert GruwezOracle dbaAuthor Commented:
nothing with oracle dbms packages ?
0
 
Geert GruwezOracle dbaAuthor Commented:
sqlplus does the job

i created my own exe in Delphi as i had some more stuff going on
and in the end i needed a user interface instead of a script

thx for the answers
0
 
Geert GruwezOracle dbaAuthor Commented:
thx guys
0
All Courses

From novice to tech pro — start learning today.