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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: warning message
Next Topic: Database is slow.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 07 18:35:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.