How to trace back the exact create table statement that was used to create a table ?

Question

Hi all,

Is it possible to trace back the exact create table statement that was used to create a table ?

Thanks, Trinity.

Answer 1

Have a look at DBMS_METADATA.GET_DDL. Note this will only retrieve the DDL required to create the table in it's current state, not necessarily the DDL used to create the table initially.

This statement illustrates:

SELECT DBMS_METADATA.GET_DDL('TABLE','<my_tab>') FROM dual;

Answer 2

You could download an application like Oracle SQL Developer. Then go to the table, and click on the "SQL" tab and it will generate the create statements, with PCTFREE and TABLESPACE and all the goodness!