Re: Capture of DDL Statement

what kind of reply is that ?

search the group(s) ! - visit his site ! - see for yourselve how much he has contributed (and still do !).

not nice, not nice at all - hope it's a language problem.

"Jerry Metz" <JMetz1_at_ix.netcom.com> wrote in message news:3C95DB91.829B7CC_at_ix.netcom.com...
> 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.
> > >
>
Received on Mon Mar 18 2002 - 12:40:28 CST