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;
/
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy