Should be in the archives. But no need to search. The script I posted
has it all.
But don't take it too seriously,
although it will give the right answer in most cases,
but so will "select null index_name from dual where dummy = '1';"
Seema Singh wrote:
> Wolfgang ,
> sorry I didn't see your posting.Where is your January 2004 posting ?thanks
>
>>
>> Just use an adaptation of the script I posted (in January 2004) to
>> detect tables that need to be reorganized:
>>
>> select owner, object_name from dba_objects
>> where object_type like 'INDEX%' and status like 'REBUILD%'
>> /
>>
--
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 08 2005 - 14:57:19 CDT
