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;