DBMS_SNAPSHOT package body invalid after installation?

From: <gmei_at_my-deja.com>
Date: 2000/08/07
Message-ID: <8mn1oe$gic$1@nnrp1.deja.com>#1/1

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 07 2000 - 00:00:00 CDT