Creating a copy of a partitioned table without the data...

Hello All,

   Is there a quick way to create an empty table having the same structure as an existing partitioned table (minus the data):

i.e sort of do this

CREATE TABLE BCK_A_PART AS SELECT * FROM A_PART WHERE 1=2; where A_PART is the partitioned table and BCK_A_PART is the copy (minus data).

PS:The above command just created the table without the partition.

Also is there a dictionary view or table to extract DDL for a users objects ?

Thanks

Ravi Alluru Received on Mon Jul 04 2005 - 14:59:06 CDT