oracle 命名空间 用户

创建新用户和命名空间：

create tablespace MarryRegist datafile 'F:\app\Administrator\oradata\orcl\MarryRegist.DBF' size 50M autoextend on next 10m maxsize unlimited;

create user MarryRegist identified by 000000 default tablespace MarryRegist;

grant connect,resource to MarryRegist;

grant dba to MarryRegist;

drop tablespace MarryRegist  INCLUDING CONTENTS AND DATAFILES;

drop user MarryRegist cascade;

转载于:https://www.cnblogs.com/guo-eric/p/8244077.html