oracle 31640,ORA-31640: unable to open dump file "/restore/psdwh/exp_dataONLY_iccs_25062

Hi,

Version 11203

I am trying to import schema into exadata machine using impdp.

The impdp is failed to open dump file.

Starting "ICCS"."SYS_IMPORT_FULL_01": userid=iccs/******** full=y TABLE_EXISTS_ACTION=APPEND

DIRECTORY=EXP_FOR_EXADATA PARALLEL=4 DUMPFILE=exp_dataONLY_iccs_25062012_%U.dmp LOGFILE=exp_dataONLY_iccs_25062012.log

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

ORA-31693: Table data object "ICCS"."INF_CALL_ERR" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/restore/psdwh/exp_dataONLY_iccs_25062012_04.dmp" for read

ORA-19505: failed to identify file "/restore/psdwh/exp_dataONLY_iccs_25062012_04.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

.....

ORA-31693: Table data object "ICCS"."CC_AGG3" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/restore/psdwh/exp_dataONLY_iccs_25062012_02.dmp" for read

ORA-19505: failed to identify file "/restore/psdwh/exp_dataONLY_iccs_25062012_02.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "ICCS"."CUST_S" 19.78 MB 580379 rows

. . imported "ICCS"."CUST_SUM_CD" 16.79 MB 843460 rows

ORA-31693: Table data object "ICCS"."BILL_CUST_SALE_TMP_C" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/restore/psdwh/exp_dataONLY_iccs_25062012_02.dmp" for read

ORA-19505: failed to identify file "/restore/psdwh/exp_dataONLY_iccs_25062012_02.dmp"

.....I verified that the file is exist in the file system :

[[email protected] psdwh]$ ls -l /restore/psdwh/exp_dataONLY_iccs_25062012_04.dmp

-rwxrwxrwx 1 oracle oinstall 701464576 Jun 25 10:36 /restore/psdwh/exp_dataONLY_iccs_25062012_04.dmpI verified that the file has the same permission as oracle user :

dm01db01{oracle} /home/oracle >id

uid=1000(oracle) gid=1001(oinstall) groups=101(fuse),1001(oinstall),1002(dba)I also verified that i have a the right permission on the directory ABOVE :

cd /restore

ls -l

drwxrwxrwx 3 oracle oinstall 9216 Jun 27 19:15 psdwhI veified that the directory exists:

SQL> select * from dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH

----------------------------------------------

SYS EXP_FOR_EXADATA /restore/psdwhI have read,write permission on the directory to PUBLIC , and as you can see there are some tables which successfully imported:

. . imported "ICCS"."CUST_S" 19.78 MB 580379 rows

. . imported "ICCS"."CUST_SUM_CD" 16.79 MB 843460 rowsPlease note that i am getting such an error each time that i am using expdp with PARALLEL and having %U in the dumpfile name .

e.g:

expdp userid=iccs/[email protected] content=data_only EXCLUDE=statistics DIRECTORY=EXP_FOR_EXADATA

PARALLEL=4 DUMPFILE=exp_dataONLY_iccs_25062012_%U.dmp LOGFILE=exp_dataONLY_iccs_25062012.logIf i am exporting without PARALLEL and %U , mean having just one dump file , i have no problem at all to import the file.

Any Advice ?

Thanks