Copying data from one table to another on the same schema

[Chintz]

I am trying to duplicate a table in a user schema. Say I have an existing table XYZ on Scotts schema and I create a identical table to that XYZ_1 on Scotts schema. Now I need to copy the data from XYZ to XYZ_1. What are my options to do that? ANd what might the fastest way be, This is a huge table. Can this be done via export/import?
ANy input would be greatly appreciated.

Thanks,
Chintz

[shadow21]

Hi,

You can do a 'create table XYZ_1 as select * from XYZ;'
It will copy table structures and data...

Cheers

Fabien

[kris109]

creata table as select..
import/export -- potentially fast
sql*plus copy -- this is slow

[mrvajrala]

Kris,

Now I am confused , I heard it either way...

Let say my table size is 5GB and which will be better option.

Thanks,
Madhu

[Chintz]

Firstly, thanks for all your input.
Also, the create table....as select * .... is faster than the import/export.

Chintz