Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-30
6
Medium Priority
?
934 Views
Last Modified: 2013-12-19
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 ?
0
Comment
Question by:Geert Gruwez
  • 4
6 Comments
 
LVL 23

Accepted Solution

by:
paquicuba earned 1400 total points
ID: 22843639
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
 
LVL 38

Author Comment

by:Geert Gruwez
ID: 22847895
ok but how to do it from a script
with something like TOAD
0
 
LVL 27

Assisted Solution

by:sujith80
sujith80 earned 600 total points
ID: 22848743
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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 38

Author Comment

by:Geert Gruwez
ID: 22865010
nothing with oracle dbms packages ?
0
 
LVL 38

Author Comment

by:Geert Gruwez
ID: 22873726
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
 
LVL 38

Author Closing Comment

by:Geert Gruwez
ID: 31511713
thx guys
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question