export error

[srilata]

while exporting I am getting the following error
EXP-00056: ORACLE error 4021 encountered
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_METADATA", line 1511
I want an immedaite solution for this.

[srilata]

I am getting the following error while exporting
EXP-00056: ORACLE error 4021 encountered
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_METADATA", line 1511

[jyaseena]

What a poor site is this , nobody answering most of the questions....!!!!!!!!!!!

[DHANEESH.K]

Time out exception occurs when the table is locked by some other process and it is waiting for the for some time to get the lock to be released. You can wait for sometime and do the export again or kill those processes which is locking the table.

While an export of a single table might work, exporting an entire user ("schema") will fail with the above error.

This problem is caused when the metadata tables needed to perform an export are missing or invalid and can sometimes occur if you have dropped or modified the XMLDB schema.

It is quite easily resolved, simply run the following script when connected as sysdba:

$ORACLE_HOME/rdbms/admin/catmeta.sql


Thanks
Dhaneesh