ORACLE创建表空间、用户

1、 查询数据文件存放路径

select file_name from dba_data_files;

2、 创建临时表空间:BKJ_TEMP

create temporary tablespace BKJ_TEMP
tempfile 'E:\APP\ADMINISTRATOR\ORADATA\BDCQZK22\BKJ_TEMP_01.dbf' 
size 100m  
autoextend on  
next 100m MAXSIZE UNLIMITED
extent management local;  
-- 添加数据文件02
alter tablespace BKJ_TEMP
add TEMPFILE 'E:\APP\ADMINISTRATOR\ORADATA\BDCQZK22\BKJ_TEMP_02.dbf'
size 128M    
autoextend on next 100M
maxsize UNLIMITED;

3、 创建数据表空间:BKJ

create tablespace BKJ
logging  
datafile 'E:\APP\ADMINISTRATOR\ORADATA\BDCQZK22\BKJ_01.dbf' 
size 500m  
autoextend on  
next 100m MAXSIZE UNLIMITED 
extent management local;  
-- 添加数据文件02
alter tablespace BKJ
add datafile 'E:\APP\ADMINISTRATOR\ORADATA\BDCQZK22\BKJ_02.dbf'
size 128M    
autoextend on next 100M
maxsize UNLIMITED;

4、 创建用户BKJ

create user BKJ identified by BKJ
  default tablespace BKJ
  temporary tablespace BKJ_TEMP
  profile DEFAULT;

5、 用户授权

grant connect to BKJ;
grant dba to BKJ;
grant resource to BKJ;
grant unlimited tablespace to BKJ;

6、 删除用户

drop user BKJ cascade;

7、 删除表空间，同时删除数据文件。

drop tablespace 表空间名 including contents and datafiles;