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...