Hi,
When I import a table about 500000 rows..This happened twice. The alert log file said that the instance was terminated by PMON duw to error 601 (lock conflict).
Why this heppens?
What should I do?
I haave Oracle 8.1.5.0.0 on Linux
Thanx...
Printable View
Hi,
When I import a table about 500000 rows..This happened twice. The alert log file said that the instance was terminated by PMON duw to error 601 (lock conflict).
Why this heppens?
What should I do?
I haave Oracle 8.1.5.0.0 on Linux
Thanx...
This is a known Bug.
You should not use MTS !!!
shutdown the database, comment out the MTS parameters in the init.ora and restart the database.
thanx! :)
You don't need to disable MTS. Workaround is have another service name in tnsnames.ora as dedicated service and use that service(@xyz) whenever you import. Thats how you can import thru dedicated connection.