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 :
[oracle@dm01db01 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.dmp
I 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 psdwh
I veified that the directory exists:
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
----------------------------------------------
SYS EXP_FOR_EXADATA /restore/psdwh
I 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 rows
Please 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/iccs@psdwh content=data_only EXCLUDE=statistics DIRECTORY=EXP_FOR_EXADATA
PARALLEL=4 DUMPFILE=exp_dataONLY_iccs_25062012_%U.dmp LOGFILE=exp_dataONLY_iccs_25062012.log
If 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