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:

create table mynewtable
as
select * from original_table
where 1 = 0;

This won't copy indexes etc though, so if you want those you will need to do them seperately.

Cheers,

Paul

*********** ORIGINAL MESSAGE ***********

On 2/12/2004 at 12:09 PM Dhanya wrote:

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