Re: creation date of a table?

From: <masnani_at_corp2.pagemart.com>
Date: 1998/03/06
Message-ID: <6dphnl$91t$1@nnrp1.dejanews.com>#1/1

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 CST