copying the table structure can be done using a false where condition
eg.

create table emp1 as select * from emp where empno = -1


as there is no record with empno as -1 only the structure of emp is passed to the new table emp1

-----Original Message-----
From: Dhanya [mailto:oracledba-ezmlmshield-x3556427.[Email address protected]
Sent: Thu 12/2/2004 12:09 PM
To: LazyDBA Discussion
Cc:
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 Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

Oracle LazyDBA home page