Home » RDBMS Server » Server Utilities » oracle table export hangs (Oracle 10g R2, Oralce Enterprise Linux 4 update 6)
oracle table export hangs [message #484291] Mon, 29 November 2010 07:29 Go to next message
dbanukesh
Messages: 96
Registered: November 2008
Location: London
Member

Dear All,

I got an problem while exporting schema. Export hangs on a particular table table. i checked the table structure and intigrity (ANALYZE TABLE user.table_name VALIDATE STRUCTURE CASCADE; ) and it seems all okay. Do you see any reason here why it is behaing so?

Thanks
Nukesh
Re: oracle table export hangs [message #484296 is a reply to message #484291] Mon, 29 November 2010 07:48 Go to previous messageGo to next message
Michel Cadot
Messages: 67956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle does not hang, it is making its job and maybe it requests time.

Regards
Michel
Re: oracle table export hangs [message #484299 is a reply to message #484296] Mon, 29 November 2010 07:54 Go to previous messageGo to next message
dbanukesh
Messages: 96
Registered: November 2008
Location: London
Member

Michel,

This is not a big table, it has 1224709 records only. It took more than 20 minuts before i abort the export. In my experiece this doesnt take this much of time.

thanks
Re: oracle table export hangs [message #484307 is a reply to message #484299] Mon, 29 November 2010 08:49 Go to previous messageGo to next message
Michel Cadot
Messages: 67956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query v$session to see what your export session is waiting for.

Regards
Michel
Re: oracle table export hangs [message #484333 is a reply to message #484291] Mon, 29 November 2010 12:49 Go to previous messageGo to next message
joy_division
Messages: 4954
Registered: February 2005
Location: East Coast USA
Senior Member
Is there a LONG datatype in the table?
Are you out of space on the device?
Re: oracle table export hangs [message #484435 is a reply to message #484333] Tue, 30 November 2010 09:07 Go to previous message
dbanukesh
Messages: 96
Registered: November 2008
Location: London
Member

I was working remotely from home and my vpn is timing out while exporting this table..don't know why. I tried from office and it went fine. But since VPN worked okay till now from home, i didn't realize that this can be reason for export to hang. Thanks for all the help though;
Previous Topic: Difference in exports, due to DIRECT=y
Next Topic: External table select error
Goto Forum:
  


Current Time: Tue Sep 28 22:11:26 CDT 2021