Re: Help: How to deal with chained_rows with raw and long raw column

Mike F wrote:
>
> For normal table, I usually do
>
> create table temp_chained_rows as select * from $owner.$table
> where rowid in (select head_rowid from chained_rows);
>
> delete from $owner.$table where rowid in (select head_rowid from
> chained_rows;
>
> insert into $owner.$table select * from temp_chained_rows;
>
> But with table with raw type, I will get an error
>
> SQL> create table temp_chained_rows as select * from motech.trfminfo;
> create table temp_chained_rows as select * from motech.trfminfo
> *
> ERROR at line 1:
> ORA-00997: illegal use of LONG datatype
>
> And it is a large table, I do not want to do a export/import for only a
> few chained rows, what should I do to eliminate the chained rows?

Depending on your definition of "a few" is, just leave it. No database will be perfectly free of chained rows. Especially of they are long or long raw and greater than your block size (8K?).

-- 
Regards,

Michael Austin            Registered Linux User #261163
First DBA Source, Inc.    http://www.firstdbasource.com
Sr. Consultant            CURRENTLY AVAILABLE
704-947-1089 (Office)
704-236-4377 (Mobile)