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: creation date of a table?

Re: creation date of a table?

From: Robert Prendin <rprendin_at_magi.com>
Date: 1998/03/06
Message-ID: <34ff766d.38373428@news.istar.ca>#1/1

Here it is...

select 	object_name, 
	object_type,
	created 
from 	dba_objects 
where 	object_name ='TEST_99'

and object_type ='TABLE';

Cheers, Robert Prendin
Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:

>Hello all,
>
> Is it possible to see the creation date of a table? Or can I do that by
>a select statement?
>
>Thanks
>Jimmy
Received on Fri Mar 06 1998 - 00:00:00 CST

Original text of this message

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