11g ocm电子lesinst实例化目标完成本课程后您应该能够.pdf

Objectives After completing this lesson, you should be able to: • Describe the process of instantiation • Prepare tables for instantiation • Perform instantiation automatically using: – Data Pump – Export and Import • Set the instantiation system change number (SCN) ly What Is Instantiation? Instantiation of database objects for Oracle Streams requires multiple steps: • Creating a shared database object at all destination sites from the database object at the source site • Populating the Streams data dictionary with metadata • Setting the instantiation SCN for shared objects at each destination site SCN: SCN: ABC table ABC table Source site Destination site Performing Instantiation 1. Prepare the objects for instantiation at the source site. 2. Create a copy of the objects at the destination site (if necessary). 3. Set the instantiation SCN for the objects at the destination site. Preparing for Instantiation Preparing for instantiation: • Is automatically performed when the DBMS_STREAMS_ADM package is used for configuring capture rules • Can be performed ly by calling DBMS_CAPTURE_ADM procedures: – PREPARE_TABLE_INSTANTIATION – PREPARE_SCHEMA_INSTANTIATION – PREPARE_GLOBAL_INSTANTIATION You must always prepare shared objects for instantiation. Preparing for Instantiation You must also prepare objects for instantiation if: • One or more rules pertaining to the object are added to the positive rule set for capture, propagation, or apply • One or more rules pertaining to the object are removed from the negative rule set for capture, propagation, or appl