--导出数据库
exp sx_dm/sx_dm@10.111.30.11:1521/orcl file=d:/sx_dm.dmp owner=sx_dm log=d:/exp.log
--导出数据表
exp dm_ltjk/insper2019 tables = 'bak_dm_jsjf_fhyfx_hz' file= abc.dmp
--建表空间
create temporary tablespace TS_SXDM_TEMP
tempfile 'E:\oracle\oradata\orcl\TS_SXDM_TEMP.dbf'
size 100m
autoextend on
next 50m
extent management local;
create tablespace TS_SXDM
logging
datafile 'E:\oracle\oradata\orcl\TS_SXDM.dbf'
size 100m
autoextend on
extent management local;
-- Create the user
create user SX_DM identified by "sx_dm"
default tablespace TS_SXDM
temporary tablespace TS_SXDM_TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant dba to SX_DM;
-- Grant/Revoke system privileges
grant unlimited tablespace to SX_DM;
--导入
imp sx_dm/sx_dm file=d:/sx_dm.dmp log=imp.log fromuser=sx_dm touser=sx_dm