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

From: Bryan & Sarah Baker <bakers65_at_cox.net>
Date: Thu, 14 Nov 2002 02:57:40 GMT
Message-ID: <EiEA9.9508$hb.7290@news1.central.cox.net>

Don,

You can't do that. You can only do dml with replication. If you want to do ddl you need to quies (spelling) the databases in the replication groups on all replicated computers, then do the ddl on each machine.

Bryan

"Don" <dchamber_at_mindspring.com> wrote in message news:3dd25962.62252078_at_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 - 20:57:40 CST