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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Ranko Mosic
*Sent:* Thursday, June 22, 2006 9:50 PM
*To:* tristan.van.essen@xxxxxxxxxxxxx
*Cc:* Leng.Kaing@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
*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@xxxxxxxxxxxxx* <tristan.van.essen@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Leng Kaing
*Sent:* Mittwoch, 21. Juni 2006 14:08
*To:* oracle-l@xxxxxxxxxxxxx
*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@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
