SQL> create tablespace "sotower"
logging
datafile '/u01/oradata/sotower.dbf' size 500m
autoextend on next 100m maxsize unlimited extent management local
segment space management auto ;
Tablespace created 提示成功
SQL> create user uap identified by uap default tablespace "UAP";
User created 提示成功
SQL> grant connect,resource to uap;
Grant succeeded 提示成功
SQL> grant dba to uap;
Grant succeeded 提示成功
logging
datafile '/u01/oradata/sotower.dbf' size 500m
autoextend on next 100m maxsize unlimited extent management local
segment space management auto ;
Tablespace created 提示成功
SQL> create user uap identified by uap default tablespace "UAP";
User created 提示成功
SQL> grant connect,resource to uap;
Grant succeeded 提示成功
SQL> grant dba to uap;
Grant succeeded 提示成功