| Error encountered while takin export on owner mode. [message #292552] |
Wed, 09 January 2008 03:32  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
