select name from v$datafile;--查询出当前数据库表空间,下面创建表空间会使用里面的路径
/opt/oracle/oradata/orcl/system01.dbf
/opt/oracle/oradata/orcl/sysaux01.dbf
/opt/oracle/oradata/orcl/undotbs01.dbf
/opt/oracle/oradata/orcl/users01.dbf
--创建表空间:使用上面查询到的表空间路径createtablespace web datafile '/opt/oracle/oradata/orcl/web.dbf' size 100M reuse autoextend onnext40M maxsize unlimited default storage(initial 128k next128k minextents 2 maxextents unlimited);
[oracle@ylm-100 orcl]$ ll
total 2206992
-rw-r----- 1 oracle oinstall 9748480 Aug 8 20:37 control01.ctl
-rw-r----- 1 oracle oinstall 9748480 Aug 8 20:37 control02.ctl
-rw-r----- 1 oracle oinstall 52429312 Aug 8 20:14 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Aug 8 20:14 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Aug 8 20:37 redo03.log
-rw-r----- 1 oracle oinstall 629153792 Aug 8 20:35 sysaux01.dbf
-rw-r----- 1 oracle oinstall 734011392 Aug 8 20:35 system01.dbf
-rw-r----- 1 oracle oinstall 61874176 Jul 25 15:51 temp01.dbf
-rw-r----- 1 oracle oinstall 602939392 Aug 8 20:35 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Aug 8 20:14 users01.dbf
-rw-r----- 1 oracle oinstall 104865792 Aug 8 20:37 web.dbf
-rw-r----- 1 oracle oinstall 104865792 Aug 8 20:34 web_temp.dbf
创建用户并指定表空间
createuser web identified by123456defaulttablespace web temporarytablespace web_temp;
sysdba连接上oralce创建临时表空间,名称是web_temp注意tablespace、tempfileselect name from v$tempfile;--查出当前数据库临时表空间,下面创建临时表空间会使用里面的存放路径;/opt/oracle/oradata/orcl/temp01.dbf[oracle@ylm-100 ~]$ cd /opt/oracle/oradata/orcl[oracle@ylm-100 orcl]$ lltotal 2103560-rw-r.