Oracle Built−in Packages- P126: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk . . Oracle PL SQL Oracle PL SQL Oracle Advonced PL SQL Oracle Wet Applkctiom Oracle PL SQL Oracle PL SQL Programming I Programming I Buir-in I Programming I Pt SQL Developer s I Language I Budt-ins 0 ne Second Edition Guide to Orocle8r features Packages with Packages Introduction Pocket Reference Pocket Reference Copyright c 2000 O Reilly Associates. All rights reserved. Registering Snapshots 616 Oracle Built-in Packages SEARCH Chapter 14 Snapshots NEXT DBMS_REFRESH Managing Snapshot Groups The DBMS_REFRESH package contains procedures for administrating snapshot groups. A snapshot group is a collection of one or more snapshots that Oracle refreshes in an atomic transaction guaranteeing that relationships among the master tables are preserved in the snapshot tables. The DBMS_REFRESH package includes packages that perform the following functions Create and destroy snapshot groups Add and subtract snapshots from snapshot groups Manually refresh snapshot groups Change properties of the snapshot group such as the refresh interval Figure Figure shows how DBMS_REFRESH works and Figure Figure illustrates snapshot groups. Figure DBMS_REFRESH components 617 Appendix A What s on the Companion Disk Figure A snapshot group Getting Started with DBMS_REFRESH The DBMS_REFRESH package is created when the Oracle database is installed. The script found in the built-in packages source directory as described in Chapter 1 contains the source code for this package s specification. This script is called by which is normally run immediately after database creation. The script creates the public synonym DBMS_REFRESH for the package and grants EXECUTE privilege on the package to public. All Oracle users can reference and make use of this package. DBMS_REFRESH Managing Snapshot Groups .
