Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_SNAPSHOT invalid after migration to 8.1.7

Re: DBMS_SNAPSHOT invalid after migration to 8.1.7

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 02 Oct 2002 18:25:45 GMT
Message-ID: <3D9B3A12.FCBE82CC@exesolutions.com> 





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
Received on Wed Oct 02 2002 - 13:25:45 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US