Create table <newtablename> as select * from <oldtablename> where 1=2;

This will copy only structure.

To get all structure details use
dbms_metadata.get_ddl(object_type,object_name)


-----Original Message-----
From: Dhanya
[mailto:oracledba-ezmlmshield-x3556427.[Email address protected]
Sent: Thursday, December 02, 2004 12:10 PM
To: LazyDBA Discussion
Subject: How will you copy the structure of a table without copying the
data?

How will you copy the structure of a table without copying the data?



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.


Oracle LazyDBA home page