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: warning message
Next Topic: Database is slow.
Goto Forum:

Current Time: Sat Oct 22 14:56:55 CDT 2016

Total time taken to generate the page: 0.07683 seconds