Post

1 follower Follow
0
Avatar

Export at User Level Instead of Table Level

Question

Is it possible to set dbreplicate to export at a user level? Failing that, if APPLY.sh is edited (in the below example) to simply OWNER=SCOTT, will that cause any issues?

Answer

The export commands created by the -all.sh are at a table level:

exp SYSTEM/******@<ORACLE\_SID> file=<filename>.dmp statistics=none flashback_scn=8003059945247 tables=SCOTT.EMP,SCOTT.DEPT log=exp_<filename>.log

Table level export means that objects such as private synonyms, sequences, packages, etc are not exported. This means they have to be manually extracted from source and created on the target. Exporting at a user level enables export of these objects.

You can edit the APPLY.sh script to your requirements. It is critical to keep the FLASHBACK_SCN intact as this is the starting point of the replication. It is advised, however, to select the SCHEMA in the setup wizard then edit the APPLY.sh

Donna Zehl Answered

Please sign in to leave a comment.