Chained Rows?

[Mr.Hanky]

Hiidey ho all;
I have a new project today, find all the extents allocated to all tables and any tables that have chained rows.

I am familiar with the UTLCHAIN.SQL but everytime I try ANALYZE TABLE I get "ORA-01496: specified chain row table form incorrect"
This is also not practical since it only does one table at a time, correct? And there are hundreds to do.
Any suggestions?

Thanks;
MH

[sambavan]

Why not write a script.

set heading off
set pagesize 1000
spool filename.sql

select "ANALYZE TABLE "||table_name||" LIST CHAINED ROWS INTO chaine_table; "
from dba_tables
where owner in ('your_ownernames');
/

spool off;

@filename.sql


Hope this would help you.

Sam

[mbaliga]

Hi,

Drop the CHAINED_ROWS table and execute UTLCHAIN.SQL to re-create it in the right format. You can write a script to analyze all the tables in the schema.

Baliga

[Mr.Hanky]

Thanks guys; I had to edit the script a little due to "ORA-00972: identifier is too long" but it seems to have worked!
MH