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 BODY07-AUG-00 07-AUG-00 2000-08-07:12:51:20 INVALID N N N SQL> connect internal;