Try the script at the bottom of the page at:
http://www.revealnet.com/newsletter-v2/rebuild.htm
<http://www.revealnet.com/newsletter-v2/rebuild.htm>
It will find indexes that need rebuilding and generate a script containing
the
ALTER INDEX REBUILD statements for those indexes that need rebuilding.
You can read the article while waiting for the script to complete ;-)
HTH
Ed
-----Original Message-----
Sent: Thursday, September 06, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
Nightly? That is a lot. Are you really entering that much data on a daily
basis?
-----Original Message-----
Sent: Thursday, September 06, 2001 8:57 AM
To: Multiple recipients of list ORACLE-L
Does anyone have any good scripts for rebuilding indexes nightly on Solaris
UNIX that they'd be willing to share? Also, in your experience is it better
to run this through UNIX cron jobs than using the Oracle OEM job scheduler?
I suspect the cron job will be the favorable answer.
Thanks in advance,
David Wagoner
Oracle DBA
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
