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

Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_SNAPSHOT package body invalid after installation?

DBMS_SNAPSHOT package body invalid after installation?

From: Guang Mei <zlmei_at_hotmail.com>
Date: Mon, 07 Aug 2000 19:11:05 GMT
Message-Id: <10582.114000@fatcity.com>


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;
Connected.
SQL> select user from dual; Received on Mon Aug 07 2000 - 14:11:05 CDT

Original text of this message

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