创建和删除Oracle数据库用户、表空间

1. 创建普通用户
  >create user username identified by username;
  >grant create tablespace, resource ,connect to username;

2. 创建表空间和用户

    2.1 创建临时表空间
  >create temporary tablespace DB_TEMP
   tempfile '/opt/oracle/oradata/mydb/ts_db_temp01.dbf'
   size 200M
   autoextend on
   next 50M maxsize unlimited
   extent management local;

    2.2 创建数据表空间
  >create tablespace DB_TABLESPACE
   logging
   datafile '/opt/oracle/oradata/mydb/ts_db_data01.dbf'
   size 500M 
   autoextend on 
   next 50M  maxsize unlimited
   extent management local;

    2.3 创建用户并指定表空间
  >create user username identified by password
   default tablespace DB_TABLESPACE
   temporary tablespace DB_TEMP;

    2.4 给用户授予权限
  >grant connect,resource to username;

3. 删除Oracle数据库用户和表空间

    3.1 删除Oracle数据库用户
  >drop user user cascade;

    3.2 删除Oracle数据库空间
  >drop tablespace tsname including contents and datafiles;