mat'l view logs
Does anyone know if you can use the logs on the master database materialized view to insert data into a table in addition to using it for the refresh? (I guess I'm assuming all entries hit the log before going to the view refresh but don't know the format for the logs) I'm in the planning stage at this point and don't have a system up to try things on yet.
ie the plan is as follows: master database or peer mview site (not sure which to make them) has base tables and mviews with logs to replicate to mview and logs on second site (one way update only, same server to support separate versions)
I have two Oracle versions so two instances to support IFS(9i) and the production db(8i). For IFS I need to track what is new in a table, in addition to the current content on the 9i side. Therefore I either need to create a table (call it collection table) that IFS can insert into as it utilizes the new records and use the collection table to query the difference between the collection and the current view or else find some other way to identify differences between the two. Copying log data as it is generated to a separate table then having IFS remove entries as it utilizes them seems like a good option. The table grows tremendously every day (in the 5 digit counts) so I don't want to start adding triggers and slowing down performance on the inserts or queries to the base table.
Any specifics and/or alternatives appreciated
thanks