|
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
|