RE: expdb error

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Tue, 21 Oct 2008 10:12:00 -0400
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F1EBAEF8E@US-BOS-MX011.na.pxl.int>


Paul,  

    I don't think that note isn't applicable in this case. From previous experience, check the definition of EXXPDP_DIR and look for one of two things.  

  1. Permission to create files therein by the Oracle owner.
  2. The existence of a previous dump file by the same name, no matter who owns it.

    Either will create the '100 error message at the bottom from the operating system.  

Dick Goulet
Senior Oracle DBA
PAREXEL International
978.313.3426
 information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Drake Sent: Monday, October 20, 2008 7:03 PM
To: joan.hsieh_at_tufts.edu
Cc: oracle_l
Subject: Re: expdb error

Joan,

See Metalink Note:453796.1

hth.

Paul

On Mon, Oct 20, 2008 at 3:52 PM, Joan Hsieh <joan.hsieh_at_tufts.edu> wrote:

        Hi List members,         

        I tried to replace exp to expdp on our aix system with the following error, I couldn't find exact error from metalink. On our solaris system without any problem. Does anyone know what's the error about?         

        Thanks,         

        Joan                                    

  • par file -------- userid=/ DIRECTORY=EXPDP_DIR dumpfile=exp_pipe.dmp schemas=sysadm
    Mon Oct 20 15:20:50 EDT 2008 Starting the Export...

        Export: Release 10.2.0.3.0 - 64bit Production on Monday, 20 October, 2008 15:20:55         

        Copyright (c) 2003, 2005, Oracle. All rights reserved.         

        Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

	With the Partitioning, OLAP and Data Mining options
	ORA-39006: internal error
	ORA-39065: unexpected master process exception in DISPATCH
	ORA-01403: no data found
	
	ORA-39097: Data Pump job encountered unexpected error 100
	
	
	--
	http://www.freelists.org/webpage/oracle-l
	
	
	



--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 21 2008 - 09:12:00 CDT

Original text of this message