Re: dbms_logstdby.skip

I think dataguard dont allow to skip just the delete dml statement.

On Mon, Mar 15, 2010 at 9:15 AM, Jason Heinrich <jheinrichdba_at_gmail.com>wrote:

> 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