oracle账户登录数据库进行如下操作：

CREATE TABLESPACE "TABLESPACEName" NOLOGGING DATAFILE 'E:\app\Administrator\oradata\orcl\TABLESPACEName.DBF' SIZE 102400K AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL ONLINE SEGMENT SPACE MANAGEMENT AUTO BLOCKSIZE 8K;
ALTER DATABASE DATAFILE '/data/oracleDB/oradata/orcl/TABLESPACEName.DBF' AUTOEXTEND ON;

CREATE USER username identified by userpassword DEFAULT TABLESPACE EPX_HRMS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;

GRANT CONNECT TO username;
GRANT RESOURCE TO username;
grant create view to username;
GRANT DBA TO username;

impdp username/userpassword directory=DATA_PUMP_DIR dumpfile=filename.DUMP schemas=username

参数

remap_schema=username:username

remap_tablespace=EPX_HRMS:EPX_HRMS1
exp username/username file=d:\username.DMP owner=username

impdp username directory=DATA_PUMP_DIR dumpfile=filename.DUMP schemas=username remap_tablespace=EPX_HRMS:EPX_HRMS1 schemas=shwgydx EXCLUDE=TABLE:\"IN\(\'FM_BLOB\'\)\"

转载于:https://www.cnblogs.com/luck666/p/10438442.html