RE: Logical Standby - skip columns?

  • From: <tristan.van.essen@xxxxxxxxxxxxx>
  • To: <Leng.Kaing@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Jun 2006 15:25:02 +0200

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

 

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.
        


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.

Other related posts: