This content has been marked as final. Show 6 replies
Bolaji80 wrote:What is it specifically doing while it "hangs"?
Hi Gurus in the house,
I am using putty to access my database server, and I am trying to export the full database into a directory I created. The problem is that the export hangs at a particular place. My oracle version is 10.2 and I have used both system and a regular user (with exp_full_databse privilege) to do the export several times. The job runs but hangs at the same place and I have a deadline approaching to get export done on this machine and 2 other ones with same problem.
What can i do in this situation? Thanks folks and happy thanksgiving in advance.
post complete results from SQL below
SELECT * FROM V$VERSION;
Thanks sir. Do you mean v$session or v$version? I could querry the v$session before the session timed out. I will run the export again and check the v$session. Meanwhile, I checked the alert log and these are some of the errors I see in the alert log
ORA-12012: error on auto execute of job 28
ORA-02049: timeout: distributed transaction waiting for lock
ORA-06512: at "HIR.IMPORT_SEC_USER_DATAS", line 153
ORA-06512: at line 1
These errors are duplicated throughout the log. What do you think sir?
From my observation, there is a lock on one of the tables in the database (IMPORT_SEC_USER_DATAS). I actually exported other schemas successfully except the user with IMPORT_SEC_USER_DATAS table.
I am trying to figure out how to work around the lock and export the full database without any structural change to the table.