Sorry for the short description. Yes I was using the logmnr.
I have resolved the issue. I did not have the grant execute on dbms_logmnr set for the user.
Thanks!
I have an application that pulls updates from the archive log, but when possible (when it is not behind), it pulls the update from the redo log rather then waiting for the update to be archived.
I am no DB expert, and trying to determine why a specific user does not have access to the...
Is there a way to limit the access to redo-log tables for a specific user?
Currently I have an issue where the user is able to see updates to one table, but not the rest of the tables in the schema being archived.
For now, the only reasons I can think of are that you can limit the access to...
I have a trigger which was developed for single row updates, but it needs to handle multi-row updates to support 2005. The basis of the trigger is that it does a value comparison on a specific field to see if it changed and then reacts based on the change.
Example:
CREATE TRIGGER...
Would it be possible to have two versions of DB2 installed on one server, and if so, is there somewhere specific I could look for detailed instructions on doing this?
Thanks,
mrt78
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.