Can you SKIP Applying only DELETE DMLs with a Logical Standby database in Data Guard 11gr2
edited Aug 15, 2011 3:17AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
I’m wanting to setup an Oracle Logical Standby database to be used for Reporting. However, I would like to SKIP the applying of any delete DMLs. This would be a combination reporting and archival database.
I'm using Oracle 11gr2.
It looks easy enough to SKIP applying of DMLs (insert,update,delete) against an object.
SQL> EXECUTE DBMS_LOGSTDBY.SKIP(STMT => 'DML', -
schema_name => 'HR', -
table_name => '%', -
proc_name => null);
With Oracle Streams Replication you can get to this level. But I have not found anything indicating I could SKIP just the delete DMLs with Data Guard Logical standby.
0