For a table, Select LAST_DDL_TIME from USER_OBJECTS (find the object with
the table name and type `TABLE`)
For a field it's not there, to my knowledge. You can setup your own auditing
though if required.
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"kielhd" <kielhd_at_freenet.de> a écrit dans le message de
news:10a4173d.0410260401.6a9606e5_at_posting.google.com...
> Hi NG,
>
> I am looking for a Data Dictionary View to find out at what time a
> certain field of a certein table was modified.
> Is there such a view in Oracle 8.1.7.?
>
> TIA,
> Henning
Received on Tue Oct 26 2004 - 08:04:28 CDT
