Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle data dictionary - Can I obtain object create/alter timestamp?
See the Oracle 8i Reference Guide, Chapter 2 Static Data Dictionary Views.
for a description of the views USER/ALL/DBA_OBJECTS columns created,
last_ddl_time and timestamp.
Tip: check the views described here and in Chapter 3 Dynamic Performance (V$) Views whenever you wonder if the Database itself could provide the info you are looking for.
Alex Blyth <alex_blyth_at_amp.com.au> schreef in berichtnieuws
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:09:54 CDT