Home » RDBMS Server » Performance Tuning » Duplicating ** million record table
Duplicating ** million record table [message #264218] Sun, 02 September 2007 02:02 Go to next message
Messages: 99
Registered: September 2005
Location: UAE
hi all,
I have a table containg about ** million records. I want to create it's duplicate another table. Wat is the best method. I can use
Create table new_tab as select * from old_table.

But is there any method so that i can do it fastest possible.

Re: Duplicating ** million record table [message #264254 is a reply to message #264218] Sun, 02 September 2007 08:29 Go to previous message
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
CTAS is the recommended method. But remember that CTAS do not enforce foreign key
Previous Topic: slow in scanning documents
Next Topic: Hash join vs NL join
Goto Forum:

Current Time: Sun Aug 20 16:08:07 CDT 2017

Total time taken to generate the page: 0.05032 seconds