Re: Analyze question - data corruption

Hi

the dbms_utility package can be used in a pl/sql script as follows

begin
dbms_utility.analyze_schema(scott,'estimate'); end;
/

obviously replace scott with the relevant schema owner.

NB DO NOT analyze sys or system schemas.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"MannyMac" <mannymac_at_aol.com> wrote in message
news:20000327141226.01940.00009253_at_ng-dc1.aol.com...


> Hello

>

> I am new to oracle and I am trying to check for data block corruption, our

> software vendor suggests to use analyze in the following format:

>

> analyze table (table name) validate structure cascade:

>

> so I am trying to put a script together to check for all the tables on the

> database, my questions are as follows:

>

> 1. I am assuming that oracle has to be up, but does the system has to be

> cleared of users?? or this can be done while the dataabase is up and being

 used


> by people during the day?

>

> 2. running  select * from dba_tables gives me more than 2,600 tables owned

 by 7


> accounts. Instead of doing the analyze one by one, is there a more

 efficient


> way of checking all these tables? I know there is a

 dbms_utility.analyze_schema


> to analyze objects by user, but I am not quite sure how to use it. The

> dbmsutil.sql doesn't seem to help me much.

>

> any help will be greatly appretiated

> Manny

> chavez_at_dkfny.com

>