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);