Oracle 10.1.0.3 RAC on Solaris 5.9.
We recently implemented a logical standby database and all is well. The
tables that are being maintained by SQL Apply in the logical standby
database have triggers. Of course, they don't fire in the standby. In the
primary database, the triggers perform DML on tables in other schemas and
those tables have user-defined datatypes. We can't maintain those tables in
the logical standby database because of the user-defined datatypes. We need
to come up with another way of performing the same DML on the non-maintained
tables in the logical standby. That is, when there is an insert into a
table that is maintained by SQL Apply, I would actually like the trigger to
fire so that the non-maintained tables get what they need. Doesn't look
like I have that option. Apparently, it would be a not insignificant effort
to convert the triggers into stored procedures which could be run on a
scheduled basis and which would capture new/changed data in the maintained
tables in order to feed the non-maintained tables. It would be my
preference to do that. Because of the user-defined datatypes, Streams isn't
an option. Doesn't look like Materialized Views would work because we have
raw columns. Advanced Queuing appears to be an option but it looks
difficult to manage (if I'm going to make my head hurt, it's going to be
because of cheap vodka, not overly complex technology). Any ideas? Rest
assured that I am searching the FMs and Metalink and Google.
Regards,
Mark Strickland
Next Online Technologies
Seattle, WA
