Oracle Perf.
Date: Fri, 18 Oct 2002 18:23:11 GMT
Message-ID: <3DB0518F.9050900_at_shaw.ca>
How do you fix a chained table with a Long Raw datatype?
I am using this script right now, which works great for all tables that
do not have a long datatype.
create table CHAINED_ROWS (
analyze table &table_name list chained rows;
create table migrated_rows as
insert into &table_name select * from migrated_rows;
analyze table &table_name compute statistics;
select table_name, num_rows, chain_cnt from dba_tables
where table_name = &table_name;
drop table CHAINED_ROWS;
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid rowid,
analyze_timestamp date
);
select orig.* from &table_name orig, chained_rows cr
where orig.rowid = cr.head_rowid
and cr.table_name = upper('&table_name');
delete from &table_name
where rowid in
(select head_rowid from chained_rows);
Greg Gerritsen Received on Fri Oct 18 2002 - 20:23:11 CEST