OraFAQ Forum: Server Utilities » Error using parfile

Home » RDBMS Server » Server Utilities » Error using parfile (Oracle 11.2.0. , Linux)

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

Error using parfile [message #592876]

Mon, 12 August 2013 16:19

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi,

When i try to run datapump export using parfile, i get following errors.

ORA-31694: master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" failed to load/unload
ORA-31617: unable to open dump file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp" for write
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at 20:12:20

FYI

The command that i used is expdp parfile=expdp.par

Here is the content of parfile.
userid=system/pwd
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=schema_expdp%U.dmp
LOGFILE=schema_expdp.log
FILESIZE=4G
COMPRESSION=ALL
PARALLEL=4
CONTENT=ALL
SCHEMAS=schema
CONSISTENT=Y

Schema size is 20 MB

Parfile name is parfile=expdp.par is created under /home/oracle directory

I ran the parfile under /home/oracle directory.

Pls help me to fix this error.

Thanks

Report message to a moderator

[Message index]

		Error using parfile By: suhasdba on Mon, 12 August 2013 16:19
		Re: Error using parfile By: BlackSwan on Mon, 12 August 2013 17:07
		Re: Error using parfile By: Michel Cadot on Tue, 13 August 2013 00:28
		Re: Error using parfile By: suhasdba on Tue, 13 August 2013 13:41
		Re: Error using parfile By: Michel Cadot on Tue, 13 August 2013 13:43
		Re: Error using parfile By: suhasdba on Tue, 13 August 2013 13:55
		Re: Error using parfile By: Michel Cadot on Tue, 13 August 2013 15:05
		Re: Error using parfile By: suhasdba on Tue, 13 August 2013 15:32
		Re: Error using parfile By: Michel Cadot on Wed, 14 August 2013 00:51
		Re: Error using parfile By: suhasdba on Thu, 15 August 2013 01:35
		Re: Error using parfile By: Michel Cadot on Thu, 15 August 2013 02:05
		Re: Error using parfile By: suhasdba on Thu, 15 August 2013 02:37
		Re: Error using parfile By: Michel Cadot on Thu, 15 August 2013 02:48
		Re: Error using parfile By: suhasdba on Thu, 15 August 2013 08:37
		Re: Error using parfile By: gazzag on Thu, 15 August 2013 08:45
		Re: Error using parfile By: suhasdba on Thu, 15 August 2013 09:00
		Re: Error using parfile By: BlackSwan on Thu, 15 August 2013 09:05
		Re: Error using parfile By: suhasdba on Thu, 15 August 2013 12:03
		Re: Error using parfile By: BlackSwan on Thu, 15 August 2013 12:07
		Re: Error using parfile By: Michel Cadot on Thu, 15 August 2013 13:06
		Re: Error using parfile By: suhasdba on Thu, 15 August 2013 23:15
		Re: Error using parfile By: Michel Cadot on Fri, 16 August 2013 01:20
		Re: Error using parfile By: suhasdba on Thu, 15 August 2013 12:14
		Re: Error using parfile By: Michel Cadot on Thu, 15 August 2013 09:34
		Re: Error using parfile By: suhasdba on Tue, 13 August 2013 13:37

Previous Topic:	import only certain number of rows in oracle
Next Topic:	Syntax error in using query parameter in expdp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 19:21:53 CDT 2024