Re: dbms_logstdby.skip

From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Mon, 15 Mar 2010 10:15:29 -0600
Message-ID: <b32e774d1003150915m1f7968f7nd22346ac6397b4f6_at_mail.gmail.com>

I don't see a response to your question, so I'll take a stab at it. My first thought would be to skip all SCHEMA_DDL, NON_SCHEMA_DDL, and DML; then unskip SCHEMA_DDL and INSERT on your particular schema. See the docs for specific syntax and usage notes.

However, I'm not sure that you can unskip something that you didn't explicitly skip. In other words, I think the unskip procedure looks for a match in its table of skip rules and removes that rule. So if you use a wildcard to skip everything, unskipping a particular schema won't work because it won't match a rule. I'm not 100% sure about this, so you'll have to try it.

You may be better off looking at other replication methods to do this.

--
Jason Heinrich


On Thu, Mar 11, 2010 at 5:24 PM, K R <kp0773_at_gmail.com> wrote:



> All,

>

> we are only trying to capture insert  for one of the schema in primary

> database . so trying to build a logical standby database instead of manual

> pl/sql   .  Can I use dbms_logstdby.skip  to skip all the update and delete

> on primary beging transferred to logical standby database.

> appreciate any suggestions .

>

> TIA

> Kart

>


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 15 2010 - 11:15:29 CDT