RE: Logical Standby - skip columns?

  • From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
  • To: <Leng.Kaing@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Jun 2006 16:10:39 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Leng Kaing
Sent: Wednesday, June 21, 2006 8:08 AM
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

 

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.
        

Other related posts: