Raj, Thanks for your response.
Could you or someone in this list give me the url. I did search asktom site but not able to locate the actual code.
- Original Message -----
Date: Monday, December 8, 2003 7:14 am
> MG, the article does something more than manual ... can you spell
> 'cut-and-paste' ??? It gives readymade code.
>
> Raj
> -------------------------------------------------------------------
> -------------
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
> -----Original Message-----
> Sent: Monday, December 08, 2003 2:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> On 2003.12.08 01:49, George Leonard wrote:
> > Hi there
> >
> > There was a article on asktom.oracle.com a while back of a stored
> > procedure/trigger extension you can add to Oracle with a
> logging table
> > that record when a table was added or modified or basically any
> object> was altered.
> >
>
> It's called a "database trigger on ddl event". If I'm not
> mistaken, the syntax is something like
> "create or relace trigger mytrig on scott.schema after
> <create|drop|alter". What is so important
> about that article? That stuff is covered in 9i SQL reference manual.
>
>
> **************************************************************************************
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable
> law. If you have received this message in error, or are not the
> named recipient(s), please immediately notify corporate MIS at
> (860) 766-2000 and delete this e-mail message from your computer,
> Thank you.
> **************************************************************************************5
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jamadagni, Rajendra
> INET: Rajendra.Jamadagni_at_espn.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> -------------------------------------------------------------------
> --
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: jaysingh1_at_optonline.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Dec 08 2003 - 09:04:26 CST
