OraFAQ Forum: Performance Tuning » URGENT: Backup of big table

Home » RDBMS Server » Performance Tuning » URGENT: Backup of big table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URGENT: Backup of big table [message #65267]

Mon, 12 July 2004 19:45

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?

Report message to a moderator

Re: URGENT: Backup of big table [message #65268 is a reply to message #65267]

Mon, 12 July 2004 20:40

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

Report message to a moderator

Re: URGENT: Backup of big table [message #65269 is a reply to message #65268]

Mon, 12 July 2004 21:02

Sam
Messages: 255
Registered: April 2000

Senior Member

Thanx Daljit

Report message to a moderator

Previous Topic:	Session parametres
Next Topic:	Efficient way to query and persist data. any leads

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 19 10:10:19 CDT 2026