Link to home
Start Free TrialLog in
Avatar of Geert G
Geert GFlag for Belgium

asked on

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 ?
ASKER CERTIFIED SOLUTION
Avatar of paquicuba
paquicuba
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Geert G

ASKER

ok but how to do it from a script
with something like TOAD
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Geert G

ASKER

nothing with oracle dbms packages ?
Avatar of Geert G

ASKER

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
Avatar of Geert G

ASKER

thx guys