步骤如下：

1.使用DBA登陆，如下：

[oracle@single ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 6月 8 11:40:18 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>
 

2.查询数据文件位置，如下：

SQL> select name from v$datafile;         

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/users01.dbf
/u01/app/oracle/oradata/orcl/example01.dbf
/u01/app/oracle/oradata/orcl/sygle
/u01/app/oracle/oradata/orcl/undotbs02.dbf

7 rows selected.
 

3.创建表空间，默认为永久的表空间

SQL> create tablespace etentest datafile '/u01/app/oracle/oradata/orcl/etentest01.dbf' size 100M autoextend on next 10M maxsize 200M;

Tablespace created.
 

etentest    ------表空间名称

size 100M    ----表空间大小

autoextend on     ---开启自动扩展

next 10M       -----每次扩展为10M

maxsize 200M    ----最大表空间为200M

4.创建表空间etentest后，查询是否存在，如下：

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/users01.dbf
/u01/app/oracle/oradata/orcl/example01.dbf
/u01/app/oracle/oradata/orcl/sygle
/u01/app/oracle/oradata/orcl/undotbs02.dbf
/u01/app/oracle/oradata/orcl/etentest01.dbf

5.查询表空间名称，如下：

SQL> select name from v$tablespace;

NAME
------------------------------------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE
EYGLE
EYGLE_TEMP
UNDOTBS02
ETENTEST

10 rows selected.
 

6.创建临时表空间，如下：

SQL> create temporary tablespace etentest_temp tempfile '/u01/app/oracle/oradata/orcl/etentest_temp.dbf' size 50M autoextend on next 10M maxsize 100M;

Tablespace created.
 

7.查询刚创建的临时表空间是否存在，如下：

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/temp01.dbf
/u01/app/oracle/oradata/orcl/eygle_temp
/u01/app/oracle/oradata/orcl/etentest_temp.dbf

8.查询刚创建的临时表空间名，如下：

SQL> select name from v$tablespace;

NAME
------------------------------------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE
EYGLE
EYGLE_TEMP
UNDOTBS02
ETENTEST
ETENTEST_TEMP

11 rows selected.
 

9.创建用户（用户必须归属于表空间），如下：

SQL> grant connect,resource,dba to eten;

Grant succeeded.

SQL> commit
  2  ;

Commit complete.