Re: WHEN TO REBUILD
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: Seema Singh <oracledbam@xxxxxxxxxxx>
- Date: Wed, 08 Jun 2005 12:52:11 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
