oracle数据库用户/表空间创建和删除

先登录，如我的用户名/密码：SYSTEM/oracle

一、用户/表空间创建：

例如：

--oracle11g：
--1.创建表空间
CREATE TABLESPACE HTSC_DATA DATAFILE 'D:\app\orcl\oradata\oracle\HTSC_DATA.dbf' SIZE 1G REUSE autoextend on next 100m maxsize unlimited;
CREATE TABLESPACE RCS_DATA DATAFILE 'D:\app\orcl\oradata\oracle\RCS_DATA.dbf' SIZE 1G REUSE autoextend on next 100m maxsize unlimited;
CREATE TABLESPACE HTSEC_DATA DATAFILE 'D:\app\orcl\oradata\oracle\HTSEC_DATA.dbf' SIZE 1G REUSE autoextend on next 100m maxsize unlimited;

--2.建用户
CREATE USER HTSC IDENTIFIED BY "HTSC" DEFAULT TABLESPACE "HTSC_DATA";
CREATE USER RCS IDENTIFIED BY "RCS" DEFAULT TABLESPACE "RCS_DATA";
CREATE USER HTSEC IDENTIFIED BY "HTSEC" DEFAULT TABLESPACE "HTSEC_DATA";

--3.赋权限
GRANT UNLIMITED TABLESPACE TO "HTSC";
GRANT "CONNECT" TO "HTSC";
GRANT "RESOURCE" TO "HTSC";
GRANT DBA TO HTSC;

GRANT UNLIMITED TABLESPACE TO "RCS";
GRANT "CONNECT" TO "RCS";
GRANT "RESOURCE" TO "RCS";
GRANT DBA TO RCS;

GRANT UNLIMITED TABLESPACE TO "HTSEC";
GRANT "CONNECT" TO "HTSEC";
GRANT "RESOURCE" TO "HTSEC";
GRANT DBA TO HTSEC;




---删除用户和表空间
drop user HTSC cascade;
drop tablespace HTSC_DATA including contents and datafiles cascade constraint;

二、删除

三、oracle默认用户及密码