Oracle Streams Capture Propagate Configuration add_schema_rules source database SCN value DBMS

Our Remote DBA Clients

Oracle Tips by Burleson

Oracle Streams
Chapter 4 - Capture and Propagate Configuration

Capture Creation - Using add_schema_rules procedure

At the source database, find the SCN value by using the following SQL statement and record the SCN values:

SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL;

Then, create the directory object where the data pump export dump file will be written.

CREATE DIRECTORY DPUMP_DIR AS '/app/home/oracle/work'
/

The data pump export is then performed by using the expdp command, which creates the NY2_SCHEMA.dmp file. Executing the following command at the operating system level on the source database hosts performs the data pump export:

>expdp strmadm/strmadm SCHEMAS=NY2 DIRECTORY=DPUMP_DIR DUMPFILE=NY2_SCHEMA.dmp FLASHBACK_SCN=11638722

The SCN value obtained from the get_system_change_number procedure has been specified to the data pump export parameter of flashback_scn.

The log file of the data pump export process looks like:

The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma

http://www.rampant-books.com/book_2004_2_streams.htm

Need an Oracle Health Check?

Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?

BC Oracle performance guru's can quickly verify every aspect of your Oracle database and provide a complete certification that your database is fully optimized.