I think, you may be better off doing this during the maintenance window. When you execute catolog.sql it invalidates the standard package which in turn invalidates many, many other packages. You may run in to major performance problems if you do this, while users are using the database..
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
| Ray Stell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 05/22/01 09:22 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: catalog.sql catproc.sql |
While it doesn't seem like a real great idea, can I get away with
running catalog.sql and catproc.sql while db has users and jobs
running? I have a real hard time getting a maintenance window,
Some docs I've seen explicitly say to do a startup rather
than startup restrict.
===============================================================
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Stell
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).
