There is special type of skip - you can use "skip procedure". You can set it
and it will be called instead of executing statement. You can then change
statement to remove updates on CLOB column.
2006/6/21, Leng Kaing <Leng.Kaing_at_hsntech.com>:
>
> Hi all,
>
>
>
> Can someone please tell me if you skip a COLUMN in a logical standby? The
> reason I'm asking is that one of our clients replicate all columns except
> for the CLOB. How do we go about doing this? I've done a skip of
> transactions and DDLs and tables, but didn't think skipping columns was
> possible. How about 10G? is this achievable in 10G?
>
>
>
> TIA,
>
>
>
> Leng.
>
>
>
> ------------------------------------------------------------------
>
> Leng Kaing
>
> Senior Oracle DBA
>
> Hansen Technologies; 2 Frederick St; Doncaster 3108
>
> Ph: +61-3-9840-3832
>
>
> Notice:
>
> This e-mail and any attachments are confidential and may contain legally
> privileged information and/or copyright material of Hansen Technologies
> Limited or third parties. Copying, distributing, disclosing, commercialising
> or otherwise acting in reliance on this e-mail and any attachments is
> strictly prohibited unless you are the addressee of this e-mail and have
> written permission to do so. If you have received this e-mail in error
> please delete this e-mail (including any copies and attachments) and contact
> Hansen Technologies Limited by return e-mail or by telephone on + 61 3 9840
> 3000. Any views expressed in this e-mail are those of the individual sender
> and may not necessarily reflect the views of or be a commitment by the
> organisation, except where the individual sender has the authority and
> expressly states them to be so.
>
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 21 2006 - 16:24:17 CDT
