Re: Table Creation Date & Time

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 27 Jul 1998 19:31:30 GMT
Message-ID: <35bfd57f.24614964@192.86.155.100>

A copy of this was sent to "Scott C." <sdcairns_at_mindspring.com> (if that email address didn't require changing) On Mon, 27 Jul 1998 13:43:37 -0400, you wrote:

>Where can I find the creation date & time of a user table in the Oracle
>(8.x) data dictionary?
>

All objects has that (user_objects, dba_objects as well)

SQL> l
1 select object_name, to_char( created, 'dd-mon-yyyy hh24:mi:ss' ) 2 from user_objects
3* where object_type = 'TABLE' and rownum = 1 SQL> /

OBJECT_NAME                    TO_CHAR(CREATED,'DD-
------------------------------ --------------------
ABCXYZ                         19-jun-1998 21:46:20

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jul 27 1998 - 14:31:30 CDT