背景：需要将数据库迁移到另外一台实例上，全量迁移数据库实例，但是只迁移表结构，数据不需要迁移，具体迁移过程如下。
1.导出语句
$expdp "/ as sysdba" cluster=no COMPRESSION=ALL DUMPFILE=test4.dmp DIRECTORY=DATA_PUMP_DIR CONTENT=METADATA_ONLY logfile=test4.log full=y
解释：
CONTENT=ALL ----将导出对象定义及其所有数据
CONTENT=DATA_ONLY------只导出对象数据,
CONTENT=METADATA_ONLY--------只导出对象定义
full=y( 全库导出): 导出除ORDSYS,MDSYS,CTXSYS,ORDPLUGINS,LBACSYS 这些系统用户之外的所有用户的数据.
Export: Release 11.2.0.1.0 - Production on Thu Dec 19 10:30:55 2019
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 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" cluster=no COMPRESSION=ALL DUMPFILE=zrrwt4.dmp DIRECTORY=DATA_PUMP_DIR CONTENT=METADATA_ONLY logfile=zrrwt4.log full=y
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
/weblogic/u01/app/oracle/admin/test4/dpdump/test4.dmp
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at 10:38:22
[oracle@host-152 /weblogic/u01/app/oracle/admin/test4/dpdump]$ll
total 39288
-rw-r--r-- 1 oracle oinstall 21200 Nov 14 2018 bb.log
-rw-r----- 1 oracle oinstall 116 Nov 8 2018 dp.log
-rw-r----- 1 oracle oinstall 35438592 Dec 19 10:38 test4.dmp
-rw-r--r-- 1 oracle oinstall 21532 Dec 19 12:25 test4.log
-rw-r----- 1 oracle oinstall 4714496 Dec 19 12:31 test4.dmp
-rw-r--r-- 1 oracle oinstall 12548 Dec 19 12:31 test4.log
2.impdp直接导入
impdp "/ as sysdba" directory=dp_dir dumpfile=test4.dmp logfile=test4.log cluster=no full=y parallel=7
Import: Release 11.2.0.4.0 - Production on Thu Dec 19 11:00:48 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": "/******** AS SYSDBA" directory=DATA_PUMP_DIR dumpfile=test4.dmp logfile=test4.log cluster=no full=y parallel=7
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"SYSAUX" already exists
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file '/data/test4/TS_YHJ_NW_DATA.DBF'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Failing sql is:
CREATE TABLESPACE "TS_YHJ_NW_DATA" DATAFILE '/data/test4/TS_YHJ_NW_DATA.DBF' SIZE 134217728 AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFA
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file '/data/test4/TS_YHJ_NW_IDX.DBF'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
根据报错，/data/test4/目录是源数据库DUMPFILE目录，在创建数据库表空间文件时候发生报错,因为目录服务器上没有此目录
可以在目标服务器上手动创建/data/test4/目录，也可以导出时使用REMAP_DATAFILE参数，此处我们直接创建此目录，并赋予oracle:oinstall属主
mkdir /data/zrrwt4/ -p
再次执行
impdp \"/ as sysdba\" directory=DATA_PUMP_DIR dumpfile=test4.dmp logfile=test4.log cluster=no full=y parallel=7
此次没有再发生报错，数据成功导入
