I think you should resolve the in-doubt transaction first.

Originally Posted by
jennifer2007
EXP-00056: ORACLE error 1591 encountered
ORA-01591: lock held by in-doubt distributed transaction 1.17.57220
. . exporting table OTHERS2 0 rows exported
My suspect is this in-doubt transation caused the ora-600.
Yes you may be right. Why not double check!
How can I skip this table?
Choose all the tables you want to export leaving the one you do not need.
How can I recover my database from ora-600 error?
I think when you resolve the in-doubt ora-600 may go off.
Its just newly installed one, or I may have to recreate it.
Mostly not needed, resolving in-doubt would get back the database.
I hope the db is up and running. Check the dba_2pc_pending table for any values for the in-doubt transaction. Then try to rollback the transaction which removes the entry from the dba_2pc_pending. Restart the database would get back your database to normal.
Why don't you give a try?
"What is past is PROLOGUE"