Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

RENAME_SHADOW_COLUMN_GROUP Procedure

This procedure renames the shadow column group of a replicated table to make it a named column group. The replicated table's master group does not need to be quiesced to run this procedure.

Syntax

DBMS_REPCAT.RENAME_SHADOW_COLUMN_GROUP (
   sname                IN VARCHAR2,
   oname                IN VARCHAR2,
   new_col_group_name   IN VARCHAR2)

Parameters

Table 18-118 RENAME_SHADOW_COLUMN_GROUP Procedure Parameters  
Parameter Description
sname

Schema in which the replicated table is located.

oname

Name of the replicated table.

new_col_group_name

Name of the new column group. The columns currently in the shadow group are placed in a column group with the name you specify.

Exceptions

Table 18-119 RENAME_SHADOW_COLUMN_GROUP Procedure Exceptions  
Exception Description
missmview

The specified schema does not exist.

nonmasterdef

Invocation site is not the master definition site.

missingobject

The specified object does not exist.

duplicategroup

The column group that was specified for creation already exists.