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

"RaviAlluru" <ravi.alluru_at_gmail.com> wrote in news:1120507146.455202.213150_at_z14g2000cwz.googlegroups.com:

> 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
>
>

DBMS_METADATA.GET_DDL FUNCTION GET_DDL RETURNS CLOB

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 OBJECT_TYPE                    VARCHAR2                IN
 NAME                           VARCHAR2                IN
 SCHEMA                         VARCHAR2                IN     DEFAULT
 VERSION                        VARCHAR2                IN     DEFAULT
 MODEL                          VARCHAR2                IN     DEFAULT
 TRANSFORM                      VARCHAR2                IN     DEFAULT