3 Replies Latest reply: Feb 27, 2013 2:37 AM by Gurjeet RSS

    error while impdp

    Gurjeet
      C:\Documents and Settings\xxxxx>impdp scott/tiger directory=DATA_PUMP_DIR dumpfile=xxxx.dmp remap_schema=old_user:new_user

      Import: Release 11.2.0.1.0 - Production on Tue Nov 20 17:31:00 2012

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORA-39001: invalid argument value
      ORA-39000: bad dump file specification
      ORA-31619: invalid dump file "E:/app/xxxx/admin/orcl/dpdump/xxxx.dmp"


      exp log file
      ---->
      ;;;
      Export: Release 10.2.0.5.0 - 64bit Production














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

      how i can import successfully ...please help

      Copyright (c) 2003, 2007, Oracle. All rights reserved.
      ;;;
      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
      FLASHBACK automatically enabled to preserve database integrity.
      Starting "SYS"."xxxxx": /******** AS SYSDBA parfile=/xxxxx/expdp_xxxx.par
      Estimate in progress using BLOCKS method...
      Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
      Total estimation using BLOCKS method: xxx GB
      Processing object type SCHEMA_EXPORT/USER
      Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
      Processing object type SCHEMA_EXPORT/ROLE_GRANT
      Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
      Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
      Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
      Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
      Processing object type SCHEMA_EXPORT/TABLE/TABLE
      Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
      Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
      Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
      Processing object type SCHEMA_EXPORT/TABLE/COMMENT
      Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
      Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
      Processing object type SCHEMA_EXPORT/VIEW/VIEW
      Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
      Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
      Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW

      ******************************************************************************
      Dump file set for SYS.EXP_xxxx is:
      /xxxxxxxx/xx_xxxx.dmp
      Job "SYS"."xxxxx" successfully completed

      Edited by: Mr. singh on Nov 20, 2012 5:38 PM