create directory tmp_dir  as '/home/oracle';

create user scott_new identified by tiger;

alter user scott_new account unlock;

alter user scott_new quota 100m on users;

grant dba to scott_new with admin option;

expdp scot/tiger tables=emp directory=TEMP_DIR dumpfile=emp.dmp logfile=expemp.log;
 
I am getting the following error while importing the dump file.

impdp scott_new/tiger tables=emp directory=TEMP_DIR dumpfile=emp.dmp logfile=impemp.log ;
ORA-31655: no data or metadata objects selected for job

ORA-31655: no data or metadata objects selected for job

c:\users\john>
c:\users\john>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 26 08:44:02 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options

orclz> grant dba to scott_new identified by tiger;

Grant succeeded.

orclz> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options

c:\users\john>expdp system/oracle file=emp.dmp tables=scott.emp

Export: Release 12.1.0.1.0 - Production on Sat Jul 26 08:44:41 2014

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "file=emp.dmp" Location: Command Line, Replaced with: "dumpfile=emp.dmp"
Legacy Mode has set reuse_dumpfiles=true parameter.
Legacy Mode has set nologfile=true parameter.
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** dumpfile=emp.dmp tables=scott.emp reuse_dumpfiles=true nologfile=true
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
. . exported "SCOTT"."EMP"                                8.75 KB      14 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
  C:\APP\ORACLE\ADMIN\ORCLZ\DPDUMP\EMP.DMP
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at Sat Jul 26 08:45:11 2014 elapsed 0 00:00:27


c:\users\john>impdp system/oracle file=emp.dmp full=yes remap_schema=scott:scott_new

Import: Release 12.1.0.1.0 - Production on Sat Jul 26 08:46:10 2014

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "file=emp.dmp" Location: Command Line, Replaced with: "dumpfile=emp.dmp"
Legacy Mode has set nologfile=true parameter.
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** dumpfile=emp.dmp full=yes remap_schema=scott:scott_new nologfile=true
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT_NEW"."EMP"                            8.75 KB      14 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39083: Object type REF_CONSTRAINT:"SCOTT_NEW"."FK_DEPTNO" failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
ALTER TABLE "SCOTT_NEW"."EMP" ADD CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "SCOTT_NEW"."DEPT" ("DEPTNO") ENABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at Sat Jul 26 08:46:27 2014 elapsed 0 00:00:15


c:\users\john>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 26 08:46:48 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options

orclz> select count(*) from scott_new.emp;

  COUNT(*)
----------
        14

orclz>

 impdp scott_new/tiger  directory=TEMP_DIR dumpfile=emp.dmp logfile=impemp.log remap_schema=scott:scott_new