使用plsql创建oracle表空间和用户

1、创建表空间。create tablespace xxxdatafile 'E:\app\Ad罪焐芡拂ministrator\virtual\oradata\orcl\xxx.dbf'size 10240M autoextend on next 500M maxsize unlimited;

2、创建用户。create user xxxidentified by "xxx"default tablespace xxxprofile DEFAULTACCOUNT UNLOCK;

3、为用户赋予表空间。alter user xxx default tablespace xxx;

4、为用户赋予权限。grant create session,create table,create view,create se鳎溻趄酃quence,unlimited tablespace to xxx;grant dba to xxx;