OraFAQ Forum: Server Utilities » oracle table export hangs

Home » RDBMS Server » Server Utilities » oracle table export hangs (Oracle 10g R2, Oralce Enterprise Linux 4 update 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle table export hangs [message #484291]

Mon, 29 November 2010 07:29

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

Report message to a moderator

Re: oracle table export hangs [message #484296 is a reply to message #484291]

Mon, 29 November 2010 07:48

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oracle does not hang, it is making its job and maybe it requests time.

Regards
Michel

Report message to a moderator

Re: oracle table export hangs [message #484299 is a reply to message #484296]

Mon, 29 November 2010 07:54

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

Report message to a moderator

Re: oracle table export hangs [message #484307 is a reply to message #484299]

Mon, 29 November 2010 08:49

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Query v$session to see what your export session is waiting for.

Regards
Michel

Report message to a moderator

Re: oracle table export hangs [message #484333 is a reply to message #484291]

Mon, 29 November 2010 12:49

joy_division
Messages: 4963
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?

Report message to a moderator

Re: oracle table export hangs [message #484435 is a reply to message #484333]

Tue, 30 November 2010 09:07

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;

Report message to a moderator

Previous Topic:	Difference in exports, due to DIRECT=y
Next Topic:	External table select error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 22:19:13 CST 2025