Re: Logical Standby - skip columns?

Thanks Ric.

Regards, Ranko.

On 6/22/06, Ric Van Dyke <ric.van.dyke_at_hotsos.com> wrote:
>
> Use the Docs. They are really quite good. Chapter 4, as I recall, in
> both the 9.2 and 10 "Oracle Data Guard Concepts and Administration" guide
> is on creating a logical and chapter 9 is on managing a logical standby.
>
>
>
>
>
> Ric Van Dyke
>
> Hotsos Enterprises
>
> Cell 248-705-0624
>
> -----------------------
>
> Hotsos Symposium March 4-8, 2007. Be there.
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ranko Mosic
> *Sent:* Thursday, June 22, 2006 9:50 PM
> *To:* tristan.van.essen_at_accenture.com
> *Cc:* Leng.Kaing_at_hsntech.com; oracle-l_at_freelists.org
> *Subject:* Re: Logical Standby - skip columns?
>
>
>
> Hi List,
>
> Barely related to initial subject - does anybody have clean/correct/tried
> document/note on how to configure logical standby ?
>
>
>
> Regards, Ranko.
>
>
>
> On 6/21/06, *tristan.van.essen_at_accenture.com* <tristan.van.essen_at_accenture.com
> > wrote:
>
> Hi Leng,
>
>
>
> It may have something to do with the fact that LOB and CLOB objects get
> stored outside the normal table content. I'm not sure though if that's the
> reason for this behavior.
>
>
>
> Regards,
>
> Tristan
>
>
>
>
> ------------------------------------------------------------------------------------
>
> Tristan van Essen
>
> Accenture Technology Solutions AG
>
> Baslerstrasse 60
>
> CH-8048 Zürich
>
> Office: +41 44 405 3245
>
> Mobile : +41 79 654 0592
>
> Email: tristan.van.essen_at_accenture.com
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Leng Kaing
> *Sent:* Mittwoch, 21. Juni 2006 14:08
>
>
> *To:* oracle-l_at_freelists.org
> *Subject:* Logical Standby - skip columns?
>
>
>
> 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
>
>
>
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information. If you have
> received it in error, please notify the sender immediately and delete the
> original. Any other use of the email by you is prohibited.
>
> 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.
>
>
>
>
> --
> Regards,
> Ranko Mosic
> Contract Senior Oracle DBA
> B. Eng, Oracle 10g, 9i Certified Database Professional
> Phone: 416-450-2785
> email: mosicr_at_rogers.com
> http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
>
>

-- 
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

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