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

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

 

  

Try this...

select count(1) from emp ;

COUNT(1)
----------
7938

create table emp1 as
(select * from emp where 1 = 2 ) ;

select count(1) from emp1 ;

COUNT(1)
----------
0


Cheers,


-----Original Message-----
From: oracledba-return-108430-DDC.NNARAYANAN=cma-cgm.[Email address protected]
[mailto:oracledba-return-108430-DDC.NNARAYANAN=cma-cgm.[Email address protected] On
Behalf Of Dhanya
Sent: Thursday, December 02, 2004 10:40 AM
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



Oracle LazyDBA home page