Re: "Replication" of LONG RAW

Jim Kennedy <kennedy-down_with_spammers_at_attbi.com> wrote:
> You will have to write a trigger to capture the fact that the table changed
> and copy the data to a holding pen (probably via the dbms_sql package.) Then
> via a database link send the data over during the replication phase - kicked
> off by using dbms_job - again use dbms_sql to send the data over. Then of
> course , you will have to write some sort of package to track errors and
> resolve simultanios updates or collisions. A shit load of work, highly
> prone to error, and taking some very talented people. Might be easier to
> change things to lobs. or have a trigger that populates a lob and use
> replication for that.

dbms_sql may by good for reading in pieces LONG data, but there is no procedures for LONG RAW (no offset value for dbms_sql.column_value_raw)

> I never done any of it; use your imagination and reduce it to as few parts
> you have to write. The problem is that if you couldn't think of ways of
> doing it then you are probably not versed enough in how Oracle works to do
> it. You could also hire a consultant.

;-) I can imagine many ways to do it, but I am looking here for some experience.
Thank you anyway.
Regards,
Lucy Received on Fri May 30 2003 - 01:49:25 CDT