Oracle7 Server Distributed Systems Volume II: Replicated Data

Supplying Asynchronous DDL

If you need to perform a task for which Oracle does not provide a method, you can supply the DDL that you want to have executed at each master site by calling the EXECUTE_DDL procedure in the DBMS_REPCAT package.

The following example creates an index on the NAME column of the EMP table at the ACCT_NY master site. Had the default, NULL, been used for the MASTER_LIST argument, the index would have been created at all master sites.

DBMS_REPCAT.EXECUTE_DDL(
	gname		=>	'acct',
	master_list	=>	'acct_ny.ny.com',
	ddl_text	=>	'CREATE INDEX name_idx ON

				 acct_rec.emp(name)');

You can call this procedure only from the master definition site. The DDL is applied asynchronously at each of the designated sites as described . The RepCatLog view contains interim status and any asynchronous error messages generated by the request. Although the replicated object group need not be quiesced when you invoke EXECUTE_DDL, you may prefer to quiesce the environment first by calling DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY.

Additional Information: The parameters for the EXECUTE_DDL procedure are described in Table 12 - 141, and the exceptions are listed in Table 12 - 142.