BigBoote66_at_hotmail.com wrote:
> 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
DBMS_JOB ... query v_$parameter as often as you wish.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 20 2005 - 17:14:44 CDT
