Re: Table creation date

From: Mike Biggin <mbiggin_at_denr.sa.gov.au>
Date: 1996/10/25
Message-ID: <32701709.7AAE@denr.sa.gov.au>#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

To list the creation dates for a specific user's objects, log on as that user in sqlplus and enter: SELECT * FROM USER_OBJECTS; For all database objects: SELECT * FROM ALL_OBJECTS;

-- 
Mike Biggin
DENR, South Australian Government
E-mail: mbiggin_at_denr.sa.gov.au
Phone: +61 8 8204 9217; Fax: +61 8 8204 9017

Unless explicitly attributed, the opinions expressed are personal
and not those of DENR or the South Australian Government.

Received on Fri Oct 25 1996 - 00:00:00 CDT