Hi,

It says on some of the table lock exis and it prevents export so query
v$lock view and check for the table .

Regds,
Vaishali.


-----Original Message-----
From: Vishal
[mailto:oracledba-ezmlmshield-x82513708.[Email address protected]
Sent: Wednesday, January 09, 2008 4:02 PM
To: LazyDBA Discussion
Subject: EXP-00008: ORACLE error 4020 encountered

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


what steps should i take?



Thanks & Regards.
********************************
Vishal Srivastava

*********************************


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

----------------------------------------------------------------------
DISCLAIMER

This email and any files transmitted with it are confidential and are solely for the use of the individual or entity to which it is addressed. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of the company shall be understood to be neither given nor endorsed by NIIT Ltd. or NIIT Technologies Ltd. Any information contained in this email, when addressed to Clients is subject to the terms and conditions in governing client contract.



Oracle LazyDBA home page