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\'\)\"