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.
You can do a 'create table XYZ_1 as select * from XYZ;'
It will copy table structures and data...
creata table as select..
import/export -- potentially fast
sql*plus copy -- this is slow
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g, 11g DBA
Now I am confused , I heard it either way...
Let say my table size is 5GB and which will be better option.
Firstly, thanks for all your input.
Also, the create table....as select * .... is faster than the import/export.
Click Here to Expand Forum to Full Width