一 新建表空间
查看数据文件位置
SYS>col file_name for a50;
SYS>select file_name,tablespace_name from dba_data_files;

FILE_NAME                       TABLESPACE_NAME
-------------------------------------------------- ------------------------------
+DATA/racdb/datafile/system.259.830791489       SYSTEM
+DATA/racdb/datafile/sysaux.260.830791807       SYSAUX
+DATA/racdb/datafile/undotbs1.261.830791981       UNDOTBS1
+DATA/racdb/datafile/example.263.830792095       EXAMPLE
+DATA/racdb/datafile/undotbs2.264.830792133       UNDOTBS2
+DATA/racdb/datafile/users.265.830792183       USERS
为新用户新建表空间，命名为etnet_data
create tablespace etnet_data datafile '+DATA/racdb/datafile/etnet_data01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;
再次查看数据文件
SYS>select file_name,tablespace_name from dba_data_files;

FILE_NAME                       TABLESPACE_NAME
-------------------------------------------------- ------------------------------
+DATA/racdb/datafile/system.259.830791489       SYSTEM
+DATA/racdb/datafile/sysaux.260.830791807       SYSAUX
+DATA/racdb/datafile/undotbs1.261.830791981       UNDOTBS1
+DATA/racdb/datafile/example.263.830792095       EXAMPLE
+DATA/racdb/datafile/undotbs2.264.830792133       UNDOTBS2
+DATA/racdb/datafile/users.265.830792183       USERS
+DATA/racdb/datafile/etnet_data01.dbf           ETNET_DATA
看到了新建的数据文件
二 新建临时表空间
查看临时文件
SYS>select file_name,tablespace_name from dba_temp_files;

FILE_NAME                       TABLESPACE_NAME
-------------------------------------------------- ------------------------------
+DATA/racdb/tempfile/temp.262.830792037        TEMP
为新用户新建临时表空间，命名为etnet_temp
create temporary tablespace etnet_temp tempfile '+DATA/racdb/tempfile/etnet_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;
再次查看临时文件
SYS>select file_name,tablespace_name from dba_temp_files;

FILE_NAME                       TABLESPACE_NAME
-------------------------------------------------- ------------------------------
+DATA/racdb/tempfile/temp.262.830792037        TEMP
+DATA/racdb/tempfile/etnet_temp01.dbf           ETNET_TEMP
可以看到新建的临时文件
三 新建用户
新建用户etnet，指明表空间为etnet_data,临时表空间为data_temp，密码为123456
create user etnet identified by 123456 default tablespace etnet_data temporary tablespace etnet_temp;
四 为新用户授权
grant connect,resource,dba to etnet;