Home » RDBMS Server » Server Utilities » export & lock
export & lock [message #69583] Tue, 05 February 2002 06:46 Go to next message
thess
Messages: 3
Registered: January 2002
Junior Member
Hello,
I would like to know if the export utility lock table ?
I have a ERP and would like to know if using export during office hour (not specialy peak hour) could bring the erp down ?

Regards
Re: export & lock [message #69585 is a reply to message #69583] Tue, 05 February 2002 07:43 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Export doesn't set an exclusive lock. If you use CONSISTENT=Y it will do a "SET TRANSACTION READ ONLY" but still will not lock the tables. If you use CONSISTENT=Y you could get an "ORA-1555 snapshot too old (rollback segment too small)" error when doing a long running export.
Re: export & lock [message #69592 is a reply to message #69583] Tue, 05 February 2002 09:13 Go to previous message
thess
Messages: 3
Registered: January 2002
Junior Member
Thank for help
Bye
Previous Topic: REPLACE in SQL Loader
Next Topic: Re: Migration of 'Sybase Database' to 'Oracle 8i '
Goto Forum:
  


Current Time: Thu Mar 28 07:25:49 CDT 2024