Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Change History for System Tables?

Change History for System Tables?

From: <BigBoote66_at_hotmail.com>
Date: 20 Oct 2005 14:28:42 -0700
Message-ID: <1129843722.581536.293740@g47g2000cwa.googlegroups.com>


Hi All,

We're using Oracle 9.2.x.x.x, and I was wondering if there's a way of keeping track of the change history of system tables - specifically v$parameter, all_tables, all_indexes, etc. What we'd like to do is set up the system such that you could look at the change history of various settings, or see when objects may have been removed, etc.

In our own applications we have built this feature for the tables that control the behavior of our apps - we can easily look back to any point in time to see what the state of our parameters were, allowing us to figure out what went wrong, etc. I would think that some similar facility must be an option that Oracle allows.

Obviously, we could do something like this by turning on auditing, but auditing seems like a rather crude solution - it would record all the statements used to make these changes, but "unscrambling the egg" by sifting through all these statements seems unnecessarily burdensome. I'm not sure if this could be done with Oracle's flashback query feature, but it doesn't seem practical - the frequency of change to these system tables is much, much less than the rate that our tables change, and I don't believe you can specify some special undo that would only be used by system tables.

Is there some other Oracle feature I'm missing that would do what I'm describing?

-Steve Received on Thu Oct 20 2005 - 16:28:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US