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: Table creation date

Re: Table creation date

From: Brian P. Mac Lean <brian.maclean_at_teldta.com>
Date: 1996/10/18
Message-ID: <326875BD.6EF@teldta.com>#1/1

krumins george wrote:
>
> Being new to Oracle, I wish to list the creation dates of the
> tables in our database. How is this possible?
>
> TIA,
> George Krumins

Look at SYS.DBA_OBJECTS.CREATED, the documentation description is "Timestamp for the creation of the object"  

--
                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo
Received on Fri Oct 18 1996 - 00:00:00 CDT

Original text of this message

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