Name

DBMS_OFFLINE_OG.END_INSTANTIATION

Synopsis

You call the END_INSTANTIATION procedure from the master definition site to flag the end of offline instantiation.

PROCEDURE DBMS_OFFLINE_OG.END_INSTANTIATION
   (gname IN VARCHAR2,
    new_site IN VARCHAR2);

Parameters are identical to those described for the BEGIN_INSTANTIATION procedure.

Exceptions

Exception Name

Number

Description

badargument

–23430

Group gname is NULL or ' ‘.

missingrepgroup

–23373

Group gname does not exist.

nonmasterdef

–23312

Routine is not being called from the master definition site.

sitealreadyexists

–23432

new_site already exists.

wrongstate

–23431

Group gname is not in NORMAL state at the master definition site.

Restrictions

  • This procedure must be run from the master definition site.

  • Group gname must be in the NORMAL state at the master definition site.

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.