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@xxxxxxxxxxxxx <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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------