Hi,


You cannot restrict just the delete DML operation in logical standby
databases. You restrict the all the DML (insert,update,delete) or don't
restrict them.


Workaround is to populate another table ( TAB_B) in the primary db
based on a trigger ( firing on all except delete ) on your main table
(TAB_A)

SKIP the DML on TAB_A from primary to logical db.
And TAB_B is populated to logical db.(which I suppose you use it for
reporting purposes).


Reddy Chatla


-----Original Message-----
From: ab265
[mailto:oracledba-ezmlmshield-x12583765.[Email address protected]
Sent: Friday, 25 April 2008 2:53 a.m.
To: LazyDBA Discussion
Subject: Logical Standby Experts (Please Answer)

Experts,

We have logical standby between two servers. It is built already
and sql
statements get applied to the standby database. I want to stop applying
only
delete statement from the source database to the standby. I mean i want
only the
insert and update to be applied to the logical standby. I am trying to
use this:
DBMS_LOGSTDBY.SKIP('delete','scott','emp',null), but the delete
statements still
getting shipped to the standby database. Would you please let me know
what's
wrong here.

Thanks,


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page