Home » RDBMS Server » Server Administration » EXP-00056
EXP-00056 [message #227191] Tue, 27 March 2007 08:43 Go to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

I am trying to export the test instance art(8.1.7.4 version on solaris9 ) and getting the below error:

> exp system/system3@art file=exp.dmp log=exp.log compress=N full=Y

Export: Release 8.1.7.4.0 - Production on Tue Mar 27 07:42:08 2007
(c) Copyright 2000 Oracle Corporation. All rights reserved.

EXP-00056:
EXP-00000: Export terminated unsuccessfully


Please note that I used the same code till saturday and the export was successfull on art with no errors.
I upgraded the production database on saturday from 8.1.7.4 to 9.2.0.7. After the upgrade the export is not successfull on art.
Please help.

[Updated on: Tue, 27 March 2007 08:45]

Report message to a moderator

Re: EXP-00056 [message #227197 is a reply to message #227191] Tue, 27 March 2007 09:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

EXP-00056:
EXP-00000: Export terminated unsuccessfully

Can you post exact error...


saturday from 8.1.7.4 to 9.2.0.7.

Are you sure you follow every step successfully simple word you done upgrade successfully ?


regards
Taj
Re: EXP-00056 [message #227199 is a reply to message #227191] Tue, 27 March 2007 09:08 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi Taj,

Below is the error i get:

/appl/oracle/admin/art>exp system/system3@art file=exp.dmp log=exp.log compress=N full=Y

Export: Release 8.1.7.4.0 - Production on Tue Mar 27 10:05:33 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.


EXP-00056:
EXP-00000: Export terminated unsuccessfully
/appl/oracle/admin/art>


Yes.The upgrade is done successfully on the production database(arp)becuase the export is succesfull in production server.
Re: EXP-00056 [message #227207 is a reply to message #227199] Tue, 27 March 2007 09:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
May be your problem is DBLINK.
http://www.dba-oracle.com/t_exp_00056_ora_942_export_database_db_link.htm


check above link hope this helps


regards
Taj
Re: EXP-00056 [message #227212 is a reply to message #227191] Tue, 27 March 2007 09:43 Go to previous message
plshelp
Messages: 205
Registered: January 2007
Senior Member
There is no dblink Taj...
Previous Topic: deleted record
Next Topic: How to analyse this problem? (please the picture.)
Goto Forum:
  


Current Time: Fri Dec 06 01:33:29 CST 2024