ora创建表空间用户

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 提示成功