Re: DBMS_SNAPSHOT invalid after migration to 8.1.7

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 02 Oct 2002 20:09:17 GMT
Message-ID: <3D9B5256.F1AA44ED@exesolutions.com>

Daniel Morgan wrote:

> Oraclion wrote:
>
> > Hi
> >
> > This package is always in 'INVALID' status after compile.
> > For information migration is from Oracle 7 Server.
> >
> > Thanks
> > Oraclion
>
> You should not be migrating objects owned by SYS or SYSTEM:
>
> EVER!
>
> Run $ORACLE_HOME/rdbms/admin/catatalog.sql followed by
> $ORACLE_HOME/rdbms/admin/catproc.sql as SYS or INTERNAL.
>
> And don't every do it again.
>
> Daniel Morgan

Typing correction ... that is catalog.sql not whatever dyslexic thing it is I typed above.

Daniel Morgan Received on Wed Oct 02 2002 - 15:09:17 CDT