| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_SNAPSHOT package body invalid after installation?
Hi:
After I installed oracle 8i on our Sun box, I manually created an instance. I have not created any tables yet. I found there is an invalid object in the database which I have not seen before:
SQL> select * from all_objects where status='INVALID';
OWNER OBJECT_NAME
------------------------------ ------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- ------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SYS DBMS_SNAPSHOT
2728 PACKAGE BODY
07-AUG-00 07-AUG-00 2000-08-07:12:51:20 INVALID N N N
SQL> connect internal;
![]() |
![]() |