RE: Replicating LONGs...

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 2 Jul 2004 11:20:05 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKEELDEPAA.mwf@rsiz.com>

make sure that the SQLPLUS session LONG size is set to at least as large as your longest LONG when you use the COPY, or you'll get a nasty surprise.

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Thomas Day Sent: Friday, July 02, 2004 8:13 AM
To: oracle-l_at_freelists.org
Subject: Re: Replicating LONGs...

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 - 10:16:48 CDT