oracle相关操作

redis-server --service-install redis.windows.conf --loglevel verbose
参考：https://blog.csdn.net/z366188741/article/details/117744446
oracle 账号：*** 密码：***
全局数据库名：***  SID：orcl

监听程序名称：
oracle 导入远程库：imp 远程用户名/密码@ip:1521/orcl fromuser= touser= file=;

项目开发环境:
创建临时表空间：create temporary tablespace JXKHTEMP tempfile 'E:/oracle19c/oracletable/tablespeace/JXKHTEMP.DBF'  size 50m    autoextend on    next 50m maxsize 20480m    extent management local;
创建表空间：create tablespace JXKH  logging  datafile 'E:/oracle19c/oracletable/tabledata/JXKH.DBF' size 50m  autoextend on  next 50m maxsize 20480m   extent management local;
创建用户：create user JXKH identified by ******  default tablespace JXKH  temporary tablespace JXKHTEMP;  
用户授权：grant connect,resource,dba to JXKH;
参考博客：https://www.cnblogs.com/sunny3158/p/15235283.html  --navicate连接oracle。
导入导出:
imp SXJXKH/ebring701 file=E:\oracle19c\oraclebak\sxjxkh\dev\SXJXKH20211213.DMP fromuser=SXJXKH touser=SXJXKH;
exp SXJXKH/ebring701 file= E:\oracle19c\oraclebak\sxjxkh\dev\SXJXKH20211220.DMP full=y

考核项目SIT环境：

登陆：sqlplus / as sysdba;
创建临时表空间：create temporary tablespace JXKHSITTEMP tempfile 'E:/oracle19c/oracletable/tablespeace/JXKHTEMPSIT.DBF'  size 50m    autoextend on    next 50m maxsize 20480m    extent management local;
创建表空间：create tablespace JXKHSIT  logging  datafile 'E:/oracle19c/oracletable/tabledata/JXKHSIT.DBF' size 50m  autoextend on  next 50m maxsize 20480m   extent management local;
创建用户：create user JXKHSIT identified by *****  default tablespace JXKHSIT  temporary tablespace JXKHSITTEMP;  
用户授权：grant connect,resource,dba to SXJXKHSIT;
导入导出:
imp SXJXKHSIT/ebring701 file=E:\oracle19c\oraclebak\sxjxkh\JXKH20211221.DMP fromuser=SXJXKH touser=JXKHSIT ignore=y
exp SXJXKH/ebring701 file= E:\oracle19c\oraclebak\sit\JXKHSIT20211213.DMP full=y

// 删除用户 
drop user JXKHSIT cascade;

// 删除表空间  临时表空间
drop tablespace JXKHSIT including contents;

drop tablespace JXKHSIT including contents and datafiles;
alter user JXKHSIT account lock;
select saddr,sid,serial#,paddr,username,status from v$session where username = 'JXKHSIT';
alter system kill session '39, 21297';
alter system kill session '43, 59918';
alter system kill session '194, 19269';
alter system kill session '269, 61441';
alter system kill session '392, 55681';
alter system kill session '409, 29275';
alter system kill session '415, 14717';
alter system kill session '188, 48793';
alter system kill session '189, 49103';