oracle 表空间以及用户创建

SQL> create temporary tablespace sunward_temp tempfile 'C:\ORACLEXE\APP\ORACLE\O
RADATA\XE\SUNWARD_TEMP.DBF'size 100m autoextend on next 100m maxsize 4096m exten
t management local;

Tablespace created.

SQL> create tablespace sunward_data logging datafile 'C:\ORACLEXE\APP\ORACLE\ORA
DATA\XE\SUNWARD_DATA.DBF'size 200m autoextend on next 200m maxsize 4096m extent
management local;

Tablespace created.

SQL> create user sunward2 identified by 123 default tablespace sunward_data temp
orary tablespace sunward_temp;

User created.

SQL> grant connect,resource,dba to sunward2;

Grant succeeded.

SQL>