2 Replies Latest reply: Jan 25, 2012 10:52 AM by mmagro RSS

    Help me: Error with "impdp"

    mmagro
      DB: Oracle Enterprise Ed. 10.2.0.2
      S.O: Windows Server 2003 R2 Std. Ed. SP2 (x86)

      I'm trying to import a table (F5543023) in a shema (TESTDTA) of my development database (VMDBDV) from a datapump file (export_PROD.dmp).
      But this datapump file (with a size of 78 Gb) has been created from my production database (incarlopsa) with the shema (PRODDTA).
      After, this datapump file was saved in a NAS, which is accessed from the database development server by a network unit through the following path:  M:\RESTORE - Also the log file:

      CREATE OR REPLACE DIRECTORY datapump_dir as 'M:\RESTORE';
      CREATE OR REPLACE DIRECTORY datapump_log as 'C:\DATAPUMP_LOG';
      GRANT read, write ON DIRECTORY datapump_dir TO system;
      GRANT read, write ON DIRECTORY datapump_log TO system;

      Then check it:

      SELECT directory_name, directory_path, grantee, privilege
      FROM user_tab_privs t, all_directories d
      WHERE t.table_name()=d.directory_name+
      ORDER BY 1,2,3;


      DIRECTORY_NAME ------------------------------
      DIRECTORY_PATH ------------------------------
      GRANTEE        PRIVILEGE
      -------------------- ----------

      DATAPUMP_DIR
      M:\RESTORE
      SYSTEM               WRITE

      DATAPUMP_DIR
      M:\RESTORE
      SYSTEM               READ

      DATAPUMP_LOG
      C:\DATAPUMP_LOG
      SYSTEM               WRITE

      DATAPUMP_LOG
      C:\DATAPUMP_LOG
      SYSTEM               READ

      +4 rows selecteds.+


      All seems OK.
      Them, I´ve created the next parfile: C:\TEMP\impdpTESTDTA_F5543023.par

      directory=datapump_dir
      dumpfile=export_PROD.dmp
      LOGFILE=datapump_log:TESTDTA_F5543023_IMPDP.log
      TABLE_EXISTS_ACTION=TRUNCATE
      REMAP_SCHEMA=PRODDTA:TESTDTA
      tables=F5543023


      And finally i launch the next impdp command:


      C:\TEMP>impdp system/password parfile=impdpTESTDTA_F5543023.par

      Import: Release 10.2.0.2.0 - Production on MiÚrcoles, 25 Enero, 2012 8:29:12

      Copyright (c) 2003, 2005, Oracle.  All rights reserved.

      Conectado a: Oracle Database 10g Release 10.2.0.2.0 - Production
      ORA-39001: valor de argumento no valido
      ORA-39000: especificacion de archivo de volcado erronea
      ORA-31640: no se ha podido abrir el archivo de volcado "M:\RESTORE\export_PROD.dmp" para lectura
      ORA-27041: no se ha podido abrir el archivo
      OSD-04002: no se ha podido abrir el archivo
      O/S-Error: (OS 3) El sistema no puede hallar la ruta especificada.


      I don't know what is happens...   I doing something wrong?
      Thanks & Regards