Oracle Import Database under Linux-Data pump mode import DMP file

The Oracle version of the DMP export data source is 12c, and my local Oracle version is 11g, which causes an error during data import

First, with the system user login to Oracle, I forgot the system password, the workaround:

[[Email protected] ~] $sqlplus "/as sysdba"

Sql>startup

Sql>conn/as SYSDBA

Sql>alter user system identified by password;

Sql>alter user System account unlock;

Sql>conn System/password

Sql> Create directory TEST as '/home/oracle/desktop/test ';

Sql> Grant read,write on the directory TEST to Scott;

Sql> SELECT * from Dba_directories;

Problem: 1, log and DMP files can not have path, DMP file placed in directory created by the path ('/home/oracle/desktop/test '), log file Oracle automatically saved in the $oracle_home directory

[Email protected] ~]$ IMPDP scott/youyou full=y directory=test dumpfile=/home/oracle/desktop/ Expiirspublish20141117.dmp logfile=/home/oracle/desktop/imp_icdmain_csd_x.log ignore=y

Import:release 11.2.0.1.0-production on Mon Jan 5 10:24:27 2015

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

Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production with the partitioning, OLAP, Da Ta Mining and Real Application testing options

Ora-39002:invalid operation

Ora-39070:unable to open the log file.

Ora-39088:file name cannot contain a path specification

[Email protected] ~]$ IMPDP scott/youyou full=y directory=test dumpfile=/home/oracle/desktop/ Expiirspublish20141117.dmp logfile=imp_icdmain_csd_x.log ignore=y import:release 11.2.0.1.0-production on Mon Jan 5 10:24:50 2015

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

Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production with the partitioning, OLAP, Da Ta Mining and Real Application testing options

Ora-39001:invalid argument value

Ora-39000:bad dump file specification

Ora-39088:file name cannot contain a path specification

Issue 2: Issue caused by version, resolve high version to low version

[Email protected] ~]$ IMPDP scott/youyou full=y directory=test dumpfile=expiirspublish20141117.dmp logfile=imp_ Icdmain_csd_x.log Ignore=y

Import:release 11.2.0.1.0-production on Mon Jan 5 10:26:09 2015

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

Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production with the partitioning, OLAP, Da Ta Mining and Real Application testing options

Ora-39001:invalid argument value

Ora-39000:bad dump file specification

Ora-39142:incompatible version number 4.1 in dump file "/home/oracle/desktop/test/expiirspublish20141117.dmp "

Source-side database version 12c, target database version 11g, source-side database version is higher than the target database version, the source side to export data with the target version,

Query version sql> show parameter compatible;

Oracle Import Database under Linux-Data pump mode import DMP file