copying large LONG RAW value between databases
Date: Mon, 27 Apr 2015 15:11:59 -0500
Message-ID: <CAJueESpqSyfgDnX80jGcOcy1HXc+ZT1_teXkJ3Df9FA94sPnew_at_mail.gmail.com>
I've got a source database which is 11.2.0.3.13 on Solaris, and an 11.2.0.4.5 target on Linux, which are using GoldenGate 12.1.2.1.0 to replicate various schemas. One of the tables stores an encrypted document in a LONG RAW column, which is approximately 70-100 KB in size. Unfortunately, this item sometimes gets silently truncated during replication... I suspect that we're hitting a DB and/or GoldenGate bug here, and will be pursuing this with Oracle once we get things whittled down to a usable test case. This table has a fairly low insert/update rate, so this issue typically affects just 1 or 2 rows.
As you're likely aware, LONG RAW columns are an utter PITA to work with using PL/SQL (especially when they're over 32 KB in length). Sadly, we aren't able to convert this column to a BLOB... not in the short term, anyway. This leaves me with a need to manually fix the offending value periodically on the downstream database, but without a good method to do so. Reloading the table from a Datapump export works for the moment, but this will become increasingly difficult to do as the table volume and DB usage increases.
What I'd like to do is setup a Java program, or something similar, which reads the good value from a single row on the source and replaces it in the corresponding row on the target. Unfortunately, this leads to a sad realization... while I'm certainly willing to put in the coding and testing effort, my Java expertise is *extremely* limited. Does anyone have something similar that you'd be willing to share, or pointers to good resources that I can reference?
I realize that LONG and LONG RAW have been deprecated for quite some time now, but I'm stuck with them for the time being. :(
Thanx!
-- "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move." -Douglas Adams -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 27 2015 - 22:11:59 CEST