Home » RDBMS Server » Server Utilities » Error encountered while takin export on owner mode. (oracle 9.2.0.8,solaris 9)
Error encountered while takin export on owner mode. [message #292552] Wed, 09 January 2008 03:32 Go to next message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
hi all
i am takin export of a owner and getting this error.


EXP-00008: ORACLE error 4020 encountered
ORA-04020: deadlock detected while trying to lock object SYS.CDC_ALTER_CTABLE_BEFORE
EXP-00000: Export terminated unsuccessfully
b

what steps should i take?
Re: Error encountered while takin export on owner mode. [message #292582 is a reply to message #292552] Wed, 09 January 2008 04:43 Go to previous messageGo to next message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
Now on restarting i am getting :


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 320307272 bytes
Fixed Size 729160 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-00604: error occurred at recursive SQL level 1
ORA-04020: deadlock detected while trying to lock object
SYS.CDC_ALTER_CTABLE_BEFORE


suggest me what to do.
Re: Error encountered while takin export on owner mode. [message #292588 is a reply to message #292582] Wed, 09 January 2008 05:05 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to refer to Note:360509.1 on Metalink.
Previous Topic: Import & Export Partition tables
Next Topic: expdp error
Goto Forum:
  


Current Time: Sat Dec 03 00:54:13 CST 2016

Total time taken to generate the page: 0.04796 seconds