(1)
cd /dm8/bin
$./disql SYSDBA/DM01SYSDBA:5236
SQL> create tablespace DMTS01 datafile '/dm8/data/DMTS01.DBF' size 500 autoextend on next 2;
SQL> create tablespace DMTS02 datafile '/dm8/data/DMTS02.DBF' size 500 autoextend on next 2;
SQL> create tablespace DMTS03 datafile '/dm8/data/DMTS03.DBF' size 500 autoextend on next 2;
SQL> create tablespace DMTS04 datafile '/dm8/data/DMTS04.DBF' size 500 autoextend on next 2;
检查：
SQL> set lineshow off
SQL> select ts.name, ts.type$, ts.cache, df.path, df.total_size*df.page_size/1024/1024 total_size_mb, df.page_size, df.auto_extend, df.next_size next_size_mb, df.max_size max_size_mb from v$tablespace ts, v$datafile df where ts.id=df.group_id order by ts.type$, ts.name, df.path;
(2)
SQL> create user DMTEST IDENTIFIED by DMTEST123 DEFAULT TABLESPACE DMTS01;
SQL> grant PUBLIC, RESOURCE, SOI, VTI to DMTEST;