Home » RDBMS Server » Performance Tuning » URGENT: Backup of big table
URGENT: Backup of big table [message #65267] Mon, 12 July 2004 19:45 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
I got to take a backup of a table with 52 lakh records and fastly. which way is preffered?
Re: URGENT: Backup of big table [message #65268 is a reply to message #65267] Mon, 12 July 2004 20:40 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Well i am not sure what do you mean by "which way is preffered", because table level backup can be taken only and only by exp utility. There is no other way to take backups at any logical entity level.

You can have a table level export and to make it faster use DIRECT=Y while exporting.

Best Regards
Daljit Singh
Re: URGENT: Backup of big table [message #65269 is a reply to message #65268] Mon, 12 July 2004 21:02 Go to previous message
Sam
Messages: 255
Registered: April 2000
Senior Member
Thanx Daljit
Previous Topic: Session parametres
Next Topic: Efficient way to query and persist data. any leads
Goto Forum:
  


Current Time: Thu Mar 28 19:12:26 CDT 2024