Re: WHEN TO REBUILD

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 08 Jun 2005 11:59:59 -0600
Message-ID: <42A7321F.40507@centrexcc.com>

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%' /

:-)

Seema Singh wrote:

> Hi,
> Does any one has script to findout which indexes need to rebuild in database
> in single run?
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 08 2005 - 14:05:09 CDT