Date of creation of table in SQL

[Reinaldommo]

Srs Good morning ..
Is there a way to pull in SQL the date of creating a table?


Thanks for the support.

[dr_gori]

Yes.
You can use this query:

Select all

select OWNER, OBJECT_NAME, OBJECT_TYPE, CREATED, LAST_DDL_TIME 
from all_objects 
where object_name='CONTRACTS'

Query return:

Select all

OWNER                  OBJECT_NAME            OBJECT_TYPE         CREATED     LAST_DDL_TIME 
---------------------- ---------------------- ------------------- ----------- ------------- 
ASSET                  CONTRACTS              TABLE               10/29/2015  10/4/2016 2:3 
 
SQL> 

: -O

[spernega]

Just remembering that if the base was created from an import, the creation date will be the date of import.

[dr_gori]

Great observation spernega.

[Reinaldommo]

Guys I only have to thank you ... Thank you very much.