Re: Oracle data dictionary - Can I obtain object create/alter timestamp?

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 14 Oct 2002 18:03:06 +0100
Message-ID: <fNCq9.21542$zX3.57539@news.indigo.ie>

In this(last ! but it only came today) month's Oracle Mag there's an helper audit trigger that records all changes...

Here's the link...

http://otn.oracle.com/oramag/oracle/02-sep/o52briefs.html#CODE

Ya need a (free) otn account for this....

"Alex Blyth" <alex_blyth_at_amp.com.au> wrote in message news:7ae9eb69.0210131704.6d1e6a11_at_posting.google.com...
> Hi All
>
> I am interested in obtaining the creation/last altered date/time for a
> user column or table from the Oracle (8i - 8.1.7) data dictionary. I
> thought of using a table such as COL$ but it doesn't contain the
> desired info.
>
> Is there a view or another table I could join to to obtain this info?
> Or, am I asking for more than Oracle think I need to know?
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Alex
Received on Mon Oct 14 2002 - 12:03:06 CDT