Oracle PL/SQL Programming, 2nd Edition

Oracle PL/SQL Programming, 2nd EditionSearch this book
Previous: C.12 DBMS_SESSIONAppendix C
Built-In Packages
Next: C.14 DBMS_SQL
 

C.13 DBMS_SNAPSHOT

The DBMS_SNAPSHOT package provides a programmatic interface through which you can manage snapshots and purge snapshot logs. For detailed information about snapshots (read-only copies of tables), see Chapter 16 in the Oracle7 Server Administrator Guide.

C.13.1 The DROP_SNAPSHOT procedure

This procedures drops the specified snapshot. The specification is:

PROCEDURE DBMS_SNAPSHOT.DROP_SNAPSHOT
   (mowner VARCHAR2,
    master VARCHAR2,
    snapshot DATE);

C.13.2 The GET_LOG_AGE procedure

This procedures gets the oldest date entry in the log. The specification is:

PROCEDURE DBMS_SNAPSHOT.GET_LOG_AGE
   (oldest IN OUT date,
    mow VARCHAR2,
    mas VARCHAR2);

C.13.3 The PURGE_LOG procedure

This procedure purges the specified log of any unnecessary rows. The specifications are:

PROCEDURE DBMS_SNAPSHOT.PURGE_LOG
   (master VARCHAR2,
    num NUMBER);

PROCEDURE DBMS_SNAPSHOT.PURGE_LOG
   (master VARCHAR2,
    num NUMBER,
    flag VARCHAR2);

C.13.4 The REFRESH procedure

This procedure causes a manual refresh of the snapshot. The procedure is overloaded so that you can specify an optional refresh option. The specifications are:

PROCEDURE DBMS_SNAPSHOT.REFRESH (snapshot VARCHAR2);

PROCEDURE DBMS_SNAPSHOT.REFRESH
   (snapshot VARCHAR2,
    op VARCHAR2);

C.13.5 The REFRESH_ALL procedure

This procedure causes a refresh of all snapshots waiting to be refreshed automatically. The specification is:

PROCEDURE DBMS_SNAPSHOT.REFRESH_ALL;

C.13.6 The SET_UP procedure

This procedure prepares the specified master site to refresh a snapshot. The specification is:

PROCEDURE DBMS_SNAPSHOT.SET_UP
   (mowner VARCHAR2,
    master VARCHAR2,
	    log IN OUT VARCHAR2,
    snapshot IN OUT date,
    snaptime IN OUT date);

C.13.7 The WRAP_UP procedure

The WRAP_UP procedure records a refresh at the master site. The specification is:

PROCEDURE DBMS_SNAPSHOT.WRAP_UP
   (mowner VARCHAR2,
    master VARCHAR2,
    sshot DATE,
    stime DATE);


Previous: C.12 DBMS_SESSIONOracle PL/SQL Programming, 2nd EditionNext: C.14 DBMS_SQL
C.12 DBMS_SESSIONBook IndexC.14 DBMS_SQL

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference