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

u518615722_at_spawnkill.ip-mobilphone.net (Mike F) wrote in message news:<l.1015604430.1291961669@[64.94.198.252]>...
> 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
>

  You could export it / import it .... but with long and long raw datatypes, there may be nothing you can do to prevent chaining. If your block size is 8k, the long types are usually longer and you'll get the chaining agian.
> 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?
>
> Thanks for your help
Received on Sun Mar 10 2002 - 00:29:51 CET