Re: creation date of a table?

Jimmy,
You can do
select owner, object_name, created
from dba_objects
where object_type='TABLE' and object_name='your_table_name';

HTH
Manish

In article <350018AD.47F7_at_comp.polyu.edu.hk>,   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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Mar 06 1998 - 00:00:00 CET