| Schema replication doesn't work [message #321695] |
Wed, 21 May 2008 01:34  |
ahmedb72
Messages: 5
Registered: May 2007
Location: UAE
|
Junior Member |
|
|
Hi all,
I configured bi-directional schema-level replication between two databases db1 (the source) and db2 (the destination) on HR schema using DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS schema. When I started the configuration, HR schema was there in db1 but not in db2.
After the procedure was succesffully executed, I noticed the HR schema created in db2 but with no objects inside it.
What could be the reason? Is it because the INCLUDE_DDL parameter was set to FALSE.
Any guide is appreciated.
Below is the code:
DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
SCHEMA_NAMES => 'hr',
SOURCE_DIRECTORY_OBJECT => 'strmadir',
DESTINATION_DIRECTORY_OBJECT => 'strmadir',
SOURCE_DATABASE => 'db1',
DESTINATION_DATABASE => 'db2',
PERFORM_ACTIONS => true,
BI_DIRECTIONAL => true,
INCLUDE_DDL => false);
end;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
