Dear Experts,
Need your urgent help please.
While importing using data pump i faced the following errors.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
Server A: Contains the shared folder (holds the dump file) with full permission to the os user on Server B
Server B:
Network drive : z:\ (connected to the shared folder on Server A)
Directory created as: create or replace directory dir_name as 'Z:\';
grant read, write on directory dir_name to user;
Import command as follows:
impdp REMAP_SCHEMA=PREMIALIVE:PREMIATEST15 REMAP_TABLESPACE=PREMIA:PREMIATEST15 PARALLEL=8 DIRECTORY=dir_name DUMPFILE=2013-09-17_full.dmp SCHEMAS=PREMIALIVE logfile=2013-09-17_premiatest15.log EXCLUDE=STATISTICS
Please help me out to get it resolve.
Thanks & Regards,
Syed