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
a quick and dirty is to add an "after ddl" trigger at database level to
capture stuff. You won't pick up things like 'alter system' etc,
because its not ddl
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"Semper in excremento, sole profundum qui variat."
------------------------------------------------------------
Received on Fri Oct 21 2005 - 08:58:54 CDT
