大家好，又见面了，我是你们的朋友全栈君。
–删除表空间
drop tablespace nacos including contents and datafiles
—-创建表空间并定义路径
create tablespace nacos –表空间名
datafile ‘D:/app/Administrator/oradata/nacos/nacos.dbf’
size 500m –大小初始值
autoextend on –自动扩展
next 50m maxsize 20480m –每次扩展50m，最大为20480m
extent management local;
—-创建临时表空间并定义路径
create temporary tablespace nacos_temp
tempfile ‘D:/app/Administrator/oradata/nacos/nacos_temp.dbf’
size 32m
autoextend on next 32m maxsize 1024m
extent management local;
—-删除用户
—-1.先查询要删除的用户连接情况，如果还有进行，则先关掉进行再删除用户
select username,sid,serial#,status from v$session where username=’nacos’;
alter system kill session ‘134,72’;
alter system kill session ‘143,64’;
—-2删除用户
drop user nacos cascade;
—-创建用户
create user nacos identified by nacos default tablespace nacos
temporary tablespace nacos_temp;
–给用户赋权限
grant connect,resource to nacos;
grant dba to nacos;
–修改用户名和密码
alter user nacos identified by 123456
–给空表分配segment(字符)
alter system set deferred_segment_creation=false;
–查看当前表空间
select INSTANCE_NAME from v$instance;
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/157374.html原文链接：https://javaforall.net
