Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: When a table was created?

Re: When a table was created?

From: Mark D Powell <mark.powell_at_eds.com>
Date: 14 Aug 2001 09:32:24 -0700
Message-ID: <178d2795.0108140832.119a5a14@posting.google.com>


"Geoff May" <Geoff.May_at_doka.de> wrote in message news:<3b7938c1$0$237$4dbef881_at_businessnews.de.uu.net>...
> Hello all,
>
> Does ORACLE store a time stamp when a table was created and/or altered?
>
> For example, I'd like to do something like:
>
> SELECT CREATE_TIMESTAMP, MODIFIED_TIMESTAMP
> FROM SOME_SYSTEM_TABLE
> WHERE TABLE_NAME LIKE '%XYZ%'
>
> MfG
>
> Geoff.

Look at the dictionary table all_objects, dba_objects or user_objects documented in the Oracle 8i Reference Manual.

UT1> select created, last_ddl_time, timestamp   2 from dba_objects
  3 where object_name = 'MARKTEST';

CREATED LAST_DDL_ TIMESTAMP

--------- --------- -------------------

30-JUN-01 09-AUG-01 2001-06-30:13:00:57 Received on Tue Aug 14 2001 - 11:32:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US