Return
-
Title
How to run the package quest_spc_find_long for all tables in a tablespace. -
Description
The package quest_spc_find_long will calculate the size of longs held in a table and allow Space Manager to choose the optimal reorg method for the table. -
Cause
quest_spc_find_long is designed to operate at the table, schema or database level, not at the tablespace level. -
Resolution
The following code will run quest_spc_find_long for all tables in a tablespace...
--change tablespace name from EXAMPLE to the desired name
begin
for c in (select t.* from dba_tables t, dba_tab_columns c
where c.table_name = t.table_name
and c.owner = t.owner
and data_type in ( 'LONG','LONG RAW')
and tablespace_name = 'EXAMPLE')
loop
quest_spc_find_long.execute(schema => c.owner,tablename =>c.table_name, include_sys => 'NO');
end loop;
end;
/