create tablespace BASTION --创建cpamsTableSpace表空间
datafile 'E:\Oracle\BASTION.dbf' --物理文件名为test1.dbf
size 1500M --初始大小为1500M
autoextend on next 100M --自动扩展,每次扩展100M
CREATE USER cpams PROFILE DEFAULT
IDENTIFIED BY cpams DEFAULT TABLESPACE BASTION
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
grant connect, resource to cpams;
GRANT READ,WRITE ON DIRECTORY DATA_PUMP_DIR to cpams;
grant DBA to cpams
创建表空间,创建数据库,给数据库权限
impdp cpams/cpams@127.0.0.1/orcl directory=DATA_PUMP_DIR dumpfile=CPAMS201804161007.DMP TABLE_EXISTS_ACTION=REPLACE
更新数据库 覆盖数据库
1 复制dmp到 orcl/dpdump
2 执行上述 代码