15.4.2.1.1 Exceptions

The BEGIN_INSTANTIATION procedure may raise the following exceptions:

15.4.2.1.2 Restrictions

The procedures in DBMS_OFFLINE_OG must be called in the appropriate order from the appropriate sites. The following example illustrates the proper use of this package.

15.4.2.1.3 Example

The following table summarizes the steps you should follow when you use the procedures in the DBMS_OFFLINE_OG package.

The following scenario shows how instantiate a new site. Here we add the site D7NY.BIGWHEEL.COM to the replication group SPROCKET using DBMS_OFFLINE_OG. Assume that the master definition site is D7CA.BIGWHEEL.COM.

1. From master definition site D7CA.BIGWHEEL.COM, we add the new master site, quiesce the replication group, and call DBMS_OFFLINE_OG.BEGIN_INSTANTIATION.

   	BEGIN
   		DBMS_REPCAT.ADD_MASTER_DATABASE(
   			gname		=> 'SPROCKET', 
   			master		=>'D7NY.BIGWHEEL.COM');;
   		DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY(gname => 'SPROCKET');
   		DBMS_OFFLINE_OG.BEGIN_INSTANTIATION(
   			gname		=>	'SPROCKET', 
   			new_site		=> 'D7NY.BIGWHEEL.COM');
   	END;

2. Perform export of schema SPROCKET from any existing master site.

3. Call RESUME_SUBSET_OF_MASTERS at master definition site.

4. Call BEGIN_LOAD from the new master site D7NY.BIGWHEEL.COM.

   	BEGIN
   		DBMS_OFFLINE_OG.BEGIN_LOAD(
   			gname	=> 'SPROCKET',
   			new_site=> 'D7NY.BIGWHEEL.COM');
   	END;
   

5. Import the SPROCKET schema into D7NY.BIGWHEEL.COM using the export file created in step 2.

6. Call END_LOAD from the new master site, D7NY.BIGWHEEL.COM.

   	BEGIN
   		DBMS_OFFLINE_OG.END_LOAD(
   			gname	=> 'SPROCKET', 
   			new_site=> 'D7NY.BIGWHEEL.COM');
   	END;

7. Call END_INSTANTIATION from the master definition site.

   	BEGIN
   		DBMS_OFFLINE_OG.END_INSTANTIATION(
   			gname => 'SPROCKET', 
   			new_site => 'D7NY.BIGWHEEL.COM');
   	END;

15.4.2.2.1 Exceptions

The BEGIN_LOAD procedure may raise the following exceptions:

15.4.2.2.2 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.

15.4.2.3.1 Exceptions

The END_INSTANTIATION procedure may raise the following exceptions:

15.4.2.3.2 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.

15.4.2.4.1 Exceptions

The END_LOAD procedure may raise the following exceptions:

15.4.2.4.2 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.

15.4.2.5.1 Exceptions

The RESUME_SUBSET_OF_MASTERS procedure may raise the following exceptions:

15.4.2.5.2 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.