Re: Replicating LONGs...

From: Thomas Day <tday6_at_csc.com>
Date: Fri, 2 Jul 2004 08:13:07 -0400
Message-ID: <OFD8E6B04D.0591B99A-ON85256EC5.0042F0CE@csc.com>

We have that very problem. What we do is replicate the non-long columns using a snapshot, use the SQLPlus copy command to copy over the primary key and the long column, and join them with a view on the replicated database. Not elegant, but then the LONG datatype is a kludge anyway.

                                                                                                                                       
                      Jose Luis                                                                                                        
                      Delgado                  To:      oracle-l_at_freelists.org                                                         
                      <joseluis_delgad         cc:                                                                                     
                      o                        Subject: Replicating LONGs...                                                           
                      @yahoo.com>                                                                                                      
                      Sent by:                                                                                                         
                      oracle-l-bounce                                                                                                  
                                                                                                                                       
                                                                                                                                       
                      07/01/2004 03:04                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to oracle-l

List...

Do any of you have an example of replicating longs data types that could share with me?

I'm starting to replicate a db with long columns (3d part), but Oracle does not support them.

Note that we cannot move to lob datatype.

TIA
Regards!
JL

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Fri Jul 02 2004 - 07:13:05 CDT