| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Logical Standby - skip columns?
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 22 2006 - 21:07:03 CDT
 |
 |