Re: dbms_logstdby.skip
- From: K R <kp0773@xxxxxxxxx>
- To: Jason Heinrich <jheinrichdba@xxxxxxxxx>
- Date: Tue, 13 Apr 2010 17:49:03 -0700
Thanks Jason,
I think dataguard dont allow to skip just the delete dml statement.
On Mon, Mar 15, 2010 at 9:15 AM, Jason Heinrich <jheinrichdba@xxxxxxxxx>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@xxxxxxxxx> 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
>>
>
>
Other related posts:
