Select into or create <table> as & LONG datatypes - what to do?

I am trying to correct a table with a high number of chained rows, so I've ran the UTLCHAIN script, analyze <table> list chained rows into chained_rows, now I want to insert the chained rows from table_a into a temp table by using:

create table table_a_chained
as select * from table_ a
where rownum in (select head_rownum from chained_rows where table_name = 'table_a')

Then delete the rows from table_a and re-insert them from the temp table.

unfortunatly one of the columns in table_a is a LONG RAW datatype and it wont allow this.

Can I work around this?

thanks in advance... Received on Mon Mar 12 2001 - 14:53:57 CST