--创建用户
create user username identified by password;
--给用户权限
grant all privileges to username;
--给用户dba权限
grant connect,resource,dba to username;
--导入备份文件
imp username/password file = C:/dmp/username_20220607.dmp log = C:/dmp/username_20220607.log full = y
--导入指定用户到指定用户
imp BM/bm123@ORCL fromuser=BM touser=BM2 file = C:/dmp/username_20220607.dmp log = C:/dmp/username_20220607.log ignore=y
--导出指定用户
exp tc/"tc_19" owner=ZM file=/usr/local/share/xjtc.dmp log = /usr/local/share/xjtc.dmp.log
--远程导出
exp tc/"tc_19"@172.16.0.3:1521/orcl file=/usr/local/share/xjtc.dmp log = /usr/local/share/xjtc.dmp.log full=y
--远程导入
imp tc/"erp-ch"@172.16.0.3:1521/orcl file = C:/tc.dmp log = C:/tc.dmp.log full = y statistics=none
linux安装oracle客户端
参考： https://blog.csdn.net/yuki5233/article/details/115724257
临时环境变量，输入以下命令起效。
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG='simplified chinese_china'.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH