2 Replies Latest reply: Dec 26, 2012 12:14 PM by Dean Gagne-Oracle RSS

    Datapump Security Changed when upgrade client to 11.2.0.3?

    user6532670
      Hi Everyone,

      I am trying to import a dump file using datapump. I can successfully import when my client is 10.2.0.4. Then my requirements changed and I needed to import the data to a different table name. I tried using the remap_table parameter, but my 10g client wouldn't work as remap_table is an 11g feature. Database is at 11.2.0.3. I installed oracle client 11.2.0.3 and now it appears I can't access the directory. I get the following error:

      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

      I've tried dropping, recreating and regranting the directory entry but I get the same error.

      Was there a security change when 11.2.0.3 came out? Why would 10.2.0.4 have no problems accessing this directory and 11.2.0.4 not be able to access it?

      uname -a
      SunOS wnpsidb8 5.10 Generic_147440-19 sun4u sparc SUNW,SPARC-Enterprise