10g添加用户 oracle_在oracle 10G下创建表空间，创建用户

步骤如下：

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.