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
fakhar55
Messages: 99
Registered: September 2005
Location: UAE
Member
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.

Thanx
Fakhar.
Re: Duplicating ** million record table [message #264254 is a reply to message #264218] Sun, 02 September 2007 08:29 Go to previous message
muzahid
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 Dec 10 01:25:05 CST 2016

Total time taken to generate the page: 0.09023 seconds