I am trying to setup Oracle replication for the first time. We have
nightly load scripts that load our tables on a master server and want
to keep one other server in sync. These scripts may drop and
re-create tables or truncate tables.
I have not been able to get replication to work for these DDL actions.
I've looked at DBMS_REPCAT and I think I can use EXECUTE_DDLt to send
out the SQL to the other server, but I don't know how to kick off this
process. I can't find a way to put a trigger on these actions.
How do I get replication to work on drops, creates, and truncates?
Any help would be greatly appreciated,
Don
Received on Wed Nov 13 2002 - 14:56:08 CET