Re: Can I rerun catalog.sql while db is open?

"Ethan Post" <epost1NOepSPAM_at_yahoo.com.invalid> wrote in message news:025775af.74476ef6_at_usw-ex0105-037.remarq.com...
> I'm getting export errors when I try to do a consistent export,
> I think that the first thing to do is re-run the catalog,
> catproc and catexp scripts. I'm doing this on a test box but
> there are some folks using it. Other than taking a performance
> hit is there any problem doing this while the db is open or
> should I wait. I have read a bunch of metalink articles about
> the problem I'm experiencing an none of them say there is any
> problem with this.
>
> Thanks,
> Ethan
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>

As these are export *views* the database should be open to create them! The only thing you can do is kick all non-dba users out, or enable restricted session mode, wait until everyone disconnected (they won't be able to reconnect) and run the script.
IIRC, I have never experienced any problem by running this in a live database. Especially the views created in catexp are used by export tools only.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Jul 18 2000 - 00:00:00 CDT