In the recent IOUG Conf there was a presentation that discussed how to do this using Oracle Streams. Regards, - Kirti --- "Leonard, George" <GLeonard@xxxxxxxxxxxxx> wrote: > Hi all > > We are in need of a solution to capture all changes to a schema, table > creates, alters drops, > procedure creates... > functions, views, indexes etc etc. > > one option is Auditing, > > The other is via a trigger based solution. > > Any ideas, views, and examples would be appreciated. > > George > ________________________________________________ > George Leonard > Oracle Database Administrator > New Dawn Technologies @ Wesbank > E-mail:gleonard@xxxxxxxxxxxxx > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------