Oracle exp report ORA-03113 error Solution

Some errors such as "ora-03113 communication channel ended" were reported in exp to guide a user's data, and a lot of information was not solved on the Internet

After careful observation, it is found that the error is returned every time the large table is reached. Because the table is a log table that can be deleted, try truncate it,

The prompt "ORA-00054 resources are busy, asked to specify Nowait, dizzy, the original table was locked, so after unlocking him exp normal

 

How to handle ORA-00054 resources busy, requiring the specified Nowait

1. Find the locked database table and related Sid, serial # And spid through the previous sentence
Select object_name as object name, S. Sid, S. Serial #, P. spid as system process number
From v $ locked_object L, dba_objects o, V $ session S, V $ PROCESS p
Where l. object_id = O. object_id and L. session_id = S. Sid and S. paddr = P. ADDR;

2. Destroy related sessions in the database
Alter system kill session 'sid, serial # '; -- Sid and serial # are the data found in step 1.

 

 

Appendix: [Oracle] ORA-03113 Error Analysis and troubleshooting (Other FAQs)