2 Replies Latest reply: Oct 30, 2012 1:12 AM by saurabh RSS

    Expdp and impdp from 10.1.0.4 to 11.2.0.3

    user521219
      On Oracle 10.1.0.4, I made a data pump as system user:
      sql> CREATE OR REPLACE DIRECTORY TEST_DIR AS 'C:\test';

      C:\> expdp system/********@BDSPROD FULL=Y directory=TEST_DIR dumpfile=BDSPROD.dmp logfile=expdpbdsprod.log
      On another server with Oracle 11.2.0.3, I tried to make impdp. There is a database with same name and structure of BDSPROD:
      sql> CREATE OR REPLACE DIRECTORY TEST_DIR AS 'C:\test';

      C:\test>impdp system/oracle@bdsprod full=Y directory=test_dir dumpfile=c:\test\bdsprod.dmp

      Import: Release 11.2.0.3.0 - Production on Mon Oct 29 14:45:08 2012

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

      Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
      ORA-39001: invalid argument value
      ORA-39000: bad dump file specification
      ORA-39088: file name cannot contain a path specification