Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Capture of DDL Statement
No value judgements were supplied. In 9i, information about all DDL is
already available, and there's no overhead in the system collecting it,
whereas triggers do impose an overhead. Roll your own, if you insist, but
you'll be performing completely unnecessary work, and so will the database.
In 8i, I didn't add anything to Tom's previous answer, since the link he
supplied is all you could ask for... though on second thoughts, perhaps he
should also have supplied a reference to the dbms_drop_the_attitude package.
HJR
-- ---------------------------------------------- Resources for Oracle: http://www.hjrdba.com =============================== "Jerry Metz" <JMetz1_at_ix.netcom.com> wrote in message news:3C95DB91.829B7CC_at_ix.netcom.com...Received on Mon Mar 18 2002 - 11:58:36 CST
> I don't recall asking for your value judgment. I asked for a methodology
to
> complete the task.
>
> "Howard J. Rogers" wrote:
>
> > For 9i, you're wasting your time. All DDL statements are included in
the
> > redo logs already, and judicious use of Log Miner will reveal precisely
who
> > did what, to what, and at what time.
> >
> > For anything other than 9i, then yes, triggers are the way to go... but
> > honestly, do you really allow "any and all users" to issue DDL?
Yikes....
> > my spine is tingling at the mere thought.
> >
> > Regards
> > HJR
> > --
> > ----------------------------------------------
> > Resources for Oracle: http://www.hjrdba.com
> > ===============================
> >
> > "Jerry Metz" <JMetz1_at_ix.netcom.com> wrote in message
> > news:3C9509CC.646536E0_at_ix.netcom.com...
> > > I want to be able to capture in a database trigger all of the changes
> > > made to the database schemas by any and all users. As a part of that,
I
> > > can get the user_id, the object name, object type, and schema with no
> > > problem via sys.dictionary_obj...
> > >
> > > I am running both Oracle9i and Oracle8i Enterprise (on separate
> > > machines).
> > >
> > > Does anyone have any ideas on how to capture the actual ddl statement
> > > (either before or after it is sent to the database)?
> > >
> > > PS - I've looked in all of the manuals that I have, so, if you are
going
> > > to send me back to the manuals for further reference checking, please
> > > point me to the appropriate manual to look at. Thanks.
> > >
>