Hot to copy a table with a LONG RAW column

[yakum0]

I have a table with a LONG RAW column Y. I have created a copy of that table called X, when I try and copy records from X to Y via "insert into Y select * from X where ..." I get the following SQL error..."ORA-00997: illegal use of LONG datatype".

Can anyone tell me how I can copy records with a LONG RAW column to a duplicate table???

Thanks

Yakumo.

 

[yakum0]

Sorry, I made a mistake in my description of the problem. The copy is actually from Y to X ie "insert into X select * from Y where ..." etc, but I suspect you probably had already figured that out!

Yakumo

 

[sem]

Try to use sql*plus COPY command or even better migrate that column to BLOB.

Regards, Dima

http://seminihin.narod.ru

 

[yakum0]

Hello Dima,

Problem with the COPY command is how do I ensure that I am copying across all of the data in the long Raw column i.e that it's not being truncated. I am aware that you can set how much you want to copy, but what to set this to for a long raw column (to ensure I copy across everything)???

Some one mentioned that you can write a PL*SQL script using cursors, but even then I think there are some restrictions on the size of the copy... yes?

If someone has a script of any sort to do this I would be very much appreciate a copy of the script.

Thanks

Yakumo.

 

[sem]

Why do you think that COPY command has any chances to truncate your data? Or other question, do you beleive that exp/imp is suitable for moving data? Don't you worry each time that during exp/imp your data may be truncated?

Regards, Dima

http://seminihin.narod.ru