DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001
    I have many snapshots configured in my database.I have also created dbms_snapshot package used to refresh the snapshots,but when I try to manually try to refresh the snapshot using the package ,it gives me the following error.
    Can anyone tell me why does it happen.

    SQL> exec sys.dbms_snapshot.refresh('AMOLP.DEPT_SNAP','C');
    begin sys.dbms_snapshot.refresh('AMOLP.DEPT_SNAP','C'); end;

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

  2. #2
    Join Date
    Nov 2000
    Hi Rohitsn,

    It means you have made the package discarded which is already created. It may be with the packages getting conflict with each other. Try and work out the earlier (similar) package, i think it wont work.

    Better you drop the snapshot group by using dbms_repcat.drop_snapshot_repgroup(). So, that the objects will be completely dropped.

    Then recreate the snapshot,group and object.

    I hope it will help you.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.