oracle 表空间以及用户创建
程序员文章站
2022-03-05 12:34:41
...
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>