Oracle Built−in Packages- P142: 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 The procedure Call the BEGIN_LOAD procedure from the new master site before you begin importing data. The specification follows PROCEDURE gname IN VARCHAR2 new_site IN VARCHAR2 These parameters are identical to those described for the BEGIN_INSTANTIATION procedure. See that section as well for an example of using the procedures in the DBMS_OFFLINE_OG procedure. Exceptions The BEGIN_LOAD procedure may raise the following exceptions Name Number Description badargument -23430 gname is NULL or missingrepgroup -23373 Group gname does not exist wrongsite -23433 Raised if BEGIN_LOAD or END_LOAD is executed at a site other than new_site wrongstate -23431 Group gname is not in NORMAL state at the master definition site Restrictions The procedures in DBMS_OFFLINE_OG must be called in the appropriate order from the appropriate sites. The example under BEGIN_INSTANTIATION illustrates the proper use of this package. The procedure You call the END_INSTANTIATION procedure from the master definition site to flag the end of offline instantiation. The specification follows PROCEDURE gname IN VARCHAR2 new_site IN VARCHAR2 These parameters are identical to those described for the BEGIN_INSTANTIATION procedure. See that section as well for an example of using the procedures in the DBMS_OFFLINE_OG package. Exceptions The END_INSTANTIATION procedure may raise the following exceptions Name Number Description badargument -23430 gname is NULL or missingrepgroup -23373 Group gname does not exist nonmasterdef -23312 Routine is not being called from master definition site sitealreadyexists -23432 New_site already exists wrongstate -23431 Group gname is not in NORMAL state at the master definition site DBMS_OFFLINE_OG Interface 696 Appendix A What s on the Companion Disk .