Home » RDBMS Server » Server Utilities » Dose Oracle lock the table during exporting (EXP)?
Dose Oracle lock the table during exporting (EXP)? [message #152759] Mon, 26 December 2005 23:41 Go to next message
webberwu
Messages: 2
Registered: March 2005
Junior Member
Hi,

Oracle has an utility EXP. It can be used to backup a table.

Dose Oracle lock the table to prevent other users from accessing/updating this table during exporting the table by EXP?

Thanks.

Report message to a moderator

Re: Dose Oracle lock the table during exporting (EXP)? [message #152873 is a reply to message #152759] Tue, 27 December 2005 06:50 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>. It can be used to backup a table
Sort of. But not exactly. Export/Import is never been a backup tool.
>>Dose Oracle lock the table to prevent other users from accessing/updating this table during exporting the table by EXP?
No.
It does not lock the table.
But when you use consistent=y during export, data is exported as of that point-in-time ( the updates
after the export started are not included in dump file).

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2250

Report message to a moderator

Previous Topic: XL File import
Next Topic: sqlloader : Multi Lingual data load
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 10 05:30:51 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.