Re: Backup a table with long columns

In article <9miuee$gdn$03$1_at_news.t-online.com>, "Nicolas says...
>
>We have an table wth long columns. Now we want to make a copy of that like
>
>creat table target_table as select * from source_table
>
>But this does not work, if the table has columns with fieldtype long.
>
>Does exist another way than to export the source_table?
>
>Regards
>
>Nicolas
>
>

see
http://osi.oracle.com/~tkyte/Misc/MoveLongs.html for another method.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp