Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Logical Standby - skip columns?

RE: Logical Standby - skip columns?

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Wed, 21 Jun 2006 16:10:39 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF5D57E6@WIN02.hotsos.com>


Nope.  

CLOBs are supported with a logical standby in 9.2 and 10 by the way.  

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 Leng Kaing Sent: Wednesday, June 21, 2006 8:08 AM
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  

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.         

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 21 2006 - 16:10:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US