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.114001@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;

USER

---

SYS SQL> alter package DBMS_SNAPSHOT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY DBMS_SNAPSHOT:

LINE/COL ERROR

-------- -----------------------------------------------------------------

508/11 PL/SQL: SQL Statement ignored
509/18 PLS-00201: identifier 'DEFTRANDEST' must be declared

---

I have run catalog.sql, catproc.sql as internal and pupbld.sql as system/manager.

I seem to remember seeing from the outpur in svrmgrl when running catproc.sql that "DBMS_SNAPSHOT" was not cmpiled properly.

Has anyone seens this also and knows why DBMS_SNAPSHOT invalid and how to fix it?

Thanks.

Guang

---

Received on Mon Aug 07 2000 - 14:11:05 CDT