16.2.2.1.1 Exceptions

The DEFINE_COLUMN_GROUP procedure may raise the following exceptions:

16.2.2.1.2 Restrictions

Note the following restrictions on calling the DEFINE_COLUMN_GROUP:

• You must call this procedure from the quiesced master definition site.

• You must regenerate replication support for the table after defining the column group with the GENERATE_REPLICATION_SUPPORT procedure.

16.2.2.1.3 Example

The DEEFINE_COLUMN_GROUP creates an empty column group -- that is, one with no members. After creating the column group, you can add columns to it with the DBMS_REPCAT.ADD_GROUPED_COLUMN procedure described later in this chapter. The following example creates an empty column group for table SPROCKET.PRODUCTS:

	BEGIN 		DBMS_REPCAT.DEFINE_COLUMN_GROUP(sname=> 'SPROCKET',  				oname => 'PRODUCTS	',  				column_group => 'CG_PRODUCTS_PRICE_COLS',  				comment => 'Comment added on '||sysdate|| ' by ' ||user); 	



END;

16.2.2.2.1 Exceptions

The DROP_COLUMN_GROUP procedure may raise the following exceptions:

16.2.2.2.2 Restrictions

Note the following restrictions on calling DROP_COLUMN_GROUP:

• You must call this procedure from the quiesced master definition site.

• You must regenerate replication support for the table after defining the column group with the GENERATE_REPLICATION_SUPPORT procedure.

16.2.2.2.3 Example

This example drops the column group CG_PRODUCTS_PRICE_COLS that was created in the CREATE_COLUMN_GROUP example:

BEGIN     DBMS_REPCAT.DROP_COLUMN_GROUP(sname > 'SPROCKET',                                    oname => 'PRODUCTS	',                                    column_group => 'CG_PRODUCTS_PRICE_COLS'); END;

16.2.2.3.1 Exceptions

The MAKE_COLUMN_GROUP procedure may raise the following exceptions:

16.2.2.3.2 Restrictions

Note the following restrictions on calling MAKE_COLUMN_GROUP:

• You must call this procedure from the quiesced master definition site.

• You must regenerate replication support for the table after defining the column group with the DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure.

16.2.2.3.3 Example

By passing "*" to the list_of_column_names parameter in MAKE_COLUMN_GROUP, you can create a column group consisting of all columns in the table.

	BEGIN 		DBMS_REPCAT.MAKE_COLUMN_GROUP(sname=> 'SPROCKET',  					     oname => 'PRODUCTS	',  					     column_group => 'CG_PRODUCTS_ALL_COLS',  					     list_of_column_names => '*'); 	END;

You can also use MAKE_COLUMN_GROUP to create a column group containing whatever subset of columns you want.

	BEGIN 		DBMS_REPCAT.MAKE_COLUMN_GROUP( 			sname		=> 'SPROCKET',  			oname 		=> 'PRODUCTS	',  			column_group	=> 'CG_PRODUCTS_MFG_COLS',  			list_of_column_names=> 'REV_LEVEL, PRODUCTION_DATE,                             PRODUCTION_STATUS'); 	END;

16.2.3.1.1 Exceptions

ADD_GROUPED_COLUMN may raise the following exceptions:

16.2.3.1.2 Restrictions

Note the following restrictions on calling ADD_GROUPED_COLUMN:

• You must call this procedure from the quiesced master definition site.

• You must regenerate replication support for the table after defining the column group with the GENERATE_REPLICATION_SUPPORT procedure.

16.2.3.1.3 Example

In this example, we add the columns CATALOG_ID and DESCRIPTION to the column group CG_PRODUCT_MFG_COLS that we created in the MAKE_COLUMN_GROUP example:

	DECLARE cg_list DBMS_REPCAT.VARCHAR2(s); 	BEGIN 		cg_list(1) := 'CATALOG_ID'; 		cg_list(1) := 'DESCRIPTION';  		DBMS_REPCAT.ADD_GROUPED_COLUMN(sname=> 'SPROCKET',  					     oname => 'PRODUCTS	',  					     column_group => 'CG_PRODUCT_MFG_COLS',  					     list_of_column_names => cg_list); 	END;

16.2.3.2.1 Exceptions

The DROP_GROUPED_COLUMN procedure may raise the following exceptions:

16.2.3.2.2 Restrictions

Note the following restrictions on calling DROP_GROUPED_COLUMN:

• You must not call this procedure from the quiesced master definition site.

• You must regenerate replication support for the table after defining the column group with the GENERATE_REPLICATION_SUPPORT procedure.

16.2.3.2.3 Example

The following example shows how to drop a column from an existing column group:

	BEGIN 		DBMS_REPCAT.DROP_GROUPED_COLUMN( 				sname		=> 'SPROCKET', 				oname		=> 'PRODUCTS', 				column_group	=> 'CG_PRODUCT_MFG_COLS', 				list_of_column_names	=> 'CATALOG_ID, DESCRIPTION'); 	END;

16.2.3.3.1 Exceptions

The COMMENT_ON_COLUMN_GROUP procedure may raise the following exceptions:

16.2.3.3.2 Restrictions

The COMMENT_ON_COLUMN_GROUP procedure must be called from the master definition site.

16.2.3.3.3 Example

You can create or change the comment field in DBA_REPCOLUMN_GROUP with the COMMENT_ON_COLUMN_GROUP procedure, as the following example illustrates:

	BEGIN 		DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP( 				sname 		=> 'SPROCKET', 				oname		=> 'PRODUCTS', 				column_group	=> 'CG_PRODUCT_MFG_COLS', 				comment		=> 'Added catalog_id + desc on '||sysdate);