创建一个永久的表空间
创建一个永久的表空间
SQL> CREATE TABLESPACE MYTABLESPACE DATAFILE '/u01/oradata/houzhh/myts01.dbf' size 100M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;
Tablespace created.
[oracle@oracle11g houzhh]$ ll
total 1754128
-rw-r----- 1 oracle oinstall 104865792 Sep 12 20:53 myts01.dbf
SQL> select * from v$tablespace;
TS# NAME INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
8 MYTABLESPACE YES NO YES
为该表空间下添加一个用户
SQL> CREATE USER xiaomi IDENTIFIED BY xiaomi DEFAULT TABLESPACE MYTABLESPACE TEMPORARY TABLESPACE MYTEMP;
User created.
SQL> grant connect,resource,dba to xiaomi;
Grant succeeded.