This discussion is archived
3 Replies Latest reply: Feb 27, 2013 12:37 AM by Gurjeet RSS

error while impdp

Gurjeet Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points