Message-ID: <F001.0048BCA2.20020628120901@fatcity.com>
Date: Fri, 28 Jun 2002 12:09:01 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Hand, Michael T" <HANDM@polaroid.com>
Subject: RE: PL/SQL & Analyze/validate
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Kevin,
Ah, yeah, I guess I could use that instead.  Needless to say, the breath of
my PL/SQL knowledge is somewhat lacking.

Mike

-----Original Message-----
Sent: Thursday, June 27, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L


Have you considered "EXECUTE IMMEDIATE 'analyze table etc. etc. etc.'"?

Our statistics gathering procedure uses that method quite successfully.
Maybe one day I'll get motivated enough and have time to convert to the
DBMS_STATS package.

Kevin Kennedy
First Point Energy Corporation 

-----Original Message-----
Sent: Thursday, June 27, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L


I have been building a PL/SQL block to run an 'analyze table validate
structure cascade' against a subset of tables in one schema of our database
(8.1.7 - daily backup copy of production).  I've initially set this up to
use OPEN_CURSOR . . . PARSE . . . EXECUTE, but was looking for a prepackaged
procedure to perform this step.  After searching the PL/SQL ref guide,
dbms_utility.analyze_part_object appears to be closest but is valid for
partitioned objects only.  Am I out of luck, or am I looking in the wrong
place.

BTW, this is a corrupt block detection routine which needs to run in pieces
as the production copy is refreshed each night.  Running against all tables
in the main schema would require at least 3 days.  Also feel free to remind
me that Export to /dev/null is an adequate test, and maybe I'll believe it
this time ;)

Mike Hand
Polaroid Corp
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  INET: HANDM@polaroid.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: kkennedy
  INET: kkennedy@firstpoint.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  INET: HANDM@polaroid.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).