Replication - How can I replicate for truncate, create, drop?

From: Don <dchamber_at_mindspring.com>
Date: 13 Nov 2002 07:56:08 -0600
Message-ID: <3dd25962.62252078@news-east.newscene.com>

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 - 07:56:08 CST