Error encountered while takin export on owner mode. [message #292552] |
Wed, 09 January 2008 03:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|