Snapshot package.

From: jaimin <jaimin_at_rolta.com>
Date: Thu, 28 Jun 2001 02:26:40 -0700
Message-ID: <F001.0033B71F.20010628020259@fatcity.com>

Hello gurus,

        I am testing dbms_snapshot package on my test server. I run "dbmssnapshot.sql" script which is in "rdbms" directory. The script gives no error.
I have snapshot called 'TEST_SNAP'.

When I execute procedure it gives me following error.

SQL> exec dbms_snapshot.refresh ('test_snap','?'); begin dbms_snapshot.refresh ('ja','?'); end;

*
ERROR at line 1:

ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_SNAPSHOT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

Can any one help me on this?

Regards,
Jaimin.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: jaimin
  INET: jaimin_at_rolta.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 28 2001 - 04:26:40 CDT