一个做开发的朋友向我求助,发一些简单的在一个项目中创建一个用户的命令,下面这些简单语句都给他救了急:

create tablespace test datafile '/u01/ora9/product/dbs/test001.dbf' size 5000m
extent management local
segment space management manual;

create user test identified by test default tablespace test temporary tablespace temp;

grant connect,resource to test;

grant unlimited tablespace to test;
alter tablespace test add datafile '/u01/ora9/product/dbs/test002.dbf' size 5000m;