Home » RDBMS Server » Server Utilities » EXP fails without termination message (Oracle 10g)
EXP fails without termination message [message #487577] Tue, 28 December 2010 22:54 Go to next message
sureshkonakanchi
Messages: 4
Registered: December 2010
Location: Hyderabad
Junior Member
I have got a serious issue in production. EXP did not complete the process. I have got Oracle Back up log file in production as follows. EXP did not write termination message like Exported successfully with warnings or without warnings. Can somebody explain what is the issue?

Log file :
---------

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Real Application Clusters option
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user XXXXXXXXXXXXXXXX
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user XXXXXXXXXXXXXXXX
About to export XXXXXXXXXXXXXXXX's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export XXXXXXXXXXXXXXXX's tables via Conventional Path ...
. . exporting table ADVICE_ITEMS 2 rows exported
. . exporting table BATCH_AUDIT 156 rows exported
. . exporting table BATCH_MASTER 125 rows exported
. . exporting table BLOCK_AUDIT 0 rows exported
. . exporting table BLOCK_MASTER 57 rows exported
. . exporting table BUNDLE_MASTER 303 rows exported
. . exporting table EARNS_ITEM_MASTER 24706 rows exported
. . exporting table EXCEPTION_MASTER 0 rows exported
. . exporting table FED_INCOMING_FILES 0 rows exported
. . exporting table FINE_DYN_RANGES 0 rows exported
. . exporting table FINE_ITEM_MASTER 0 rows exported
. . exporting table FINE_JOB_MASTER 0 rows exported
. . exporting table FINE_KEYS_MASTER 0 rows exported
. . exporting table GL_TXN_MASTER 0 rows exported
. . exporting table IRD_ITEMS 9 rows exported
. . exporting table ITEM_10042010_1 415 rows exported
. . exporting table ITEM_10042010_10 76 rows exported
. . exporting table ITEM_10042010_11 10 rows exported
. . exporting table ITEM_10042010_12 16 rows exported
. . exporting table ITEM_10042010_13 3 rows exported
. . exporting table ITEM_10042010_15 2 rows exported
. . exporting table ITEM_10042010_16 898 rows exported
. . exporting table ITEM_10042010_17 122 rows exported
. . exporting table ITEM_10042010_18 1 rows exported
. . exporting table ITEM_10042010_2 21 rows exported
. . exporting table ITEM_10042010_29 82 rows exported
. . exporting table ITEM_10042010_3 129 rows exported
. . exporting table ITEM_10042010_32 1 rows exported
. . exporting table ITEM_10042010_34 8 rows exported
. . exporting table ITEM_10042010_37 35 rows exported
. . exporting table ITEM_10042010_39 193 rows exported
. . exporting table ITEM_10042010_4 48 rows exported
. . exporting table ITEM_10042010_40 22 rows exported
. . exporting table ITEM_10042010_5 7 rows exported
. . exporting table ITEM_10042010_6 19 rows exported
. . exporting table ITEM_10042010_7 80 rows exported
. . exporting table ITEM_10042010_8 16 rows exported
. . exporting table ITEM_10042010_9 12 rows exported
. . exporting table ITEM_AUDIT 29678 rows exported
. . exporting table ITEM_DETAILS_10042010_1 1456 rows exported

[Updated on: Tue, 28 December 2010 22:59]

Report message to a moderator

Re: EXP fails without termination message [message #487586 is a reply to message #487577] Wed, 29 December 2010 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is waiting for something or someone killed it.

Regards
Michel
Re: EXP fails without termination message [message #487602 is a reply to message #487586] Wed, 29 December 2010 01:42 Go to previous messageGo to next message
sureshkonakanchi
Messages: 4
Registered: December 2010
Location: Hyderabad
Junior Member
Thanks for your reply. But no one has killed it because it is production server. Can you suggest me which things causes to wait the EXP process ?

Thanks
Suresh

[Updated on: Wed, 29 December 2010 03:07]

Report message to a moderator

Re: EXP fails without termination message [message #487606 is a reply to message #487602] Wed, 29 December 2010 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But no one has killed it because it production server.

That's not a good reason, human errors exist.

Quote:
Can you suggest me which things causes to wait the EXP process ?

Query v$session.

Regards
Michel
Re: EXP fails without termination message [message #487615 is a reply to message #487606] Wed, 29 December 2010 02:57 Go to previous messageGo to next message
sureshkonakanchi
Messages: 4
Registered: December 2010
Location: Hyderabad
Junior Member
I appreciate your quick reply.

Yes, you are right. But we get this problem every day in production server. Client does not do anything without informing to us. Client informs us for even resetting IIS also.
Re: EXP fails without termination message [message #487622 is a reply to message #487615] Wed, 29 December 2010 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you can't investigate the case, you can't know the source and have to live with it.

Regards
Michel
Re: EXP fails without termination message [message #487660 is a reply to message #487577] Wed, 29 December 2010 08:05 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
sureshkonakanchi wrote on Tue, 28 December 2010 23:54
I have got a serious issue in production. EXP did not complete the process.


No space left on device?
Re: EXP fails without termination message [message #487685 is a reply to message #487606] Wed, 29 December 2010 23:50 Go to previous message
sureshkonakanchi
Messages: 4
Registered: December 2010
Location: Hyderabad
Junior Member
More than enough(20GB) space is there.Our dmp file takes only 5MB.
Previous Topic: Oracle Data Integrator (ODI)
Next Topic: Getting "'localconfig' is not recognized as an internal or external command,"
Goto Forum:
  


Current Time: Tue May 21 19:02:35 CDT 2024