1.创建表空间无限制大小
create tablespace ETL
logging
datafile’/opt/oracle/oradata/etl/etl.dbf’
size 200M
autoextend on
next 200M
extent management local;
2.创建表空间限制大小
create tablespace ETL
logging
datafile’/opt/oracle/oradata/etl/etl.dbf’
size 200M
autoextend on
next 200M maxsize 2048M
extent management local;
3.创建临时表空间限制大小
create temporary tablespace etl_temp
tempfile ‘/opt/oracle/oradata/etl/etl_temp.dbf’
size 50M
autoextend on
next 50M maxsize 2048M
extent management local;
4.查看数据表空间不包含临时表
select tablespace_name from dba_data_files;
5.查看数据表空间包含临时表
select name from v$tablespace;
6.创建用户并指定表空间
create user etl identified by etl123
default tablespace etl
temporary tablespace temp;
7.用户授予权限
grant connect,resource,dba to etl;
8.修改用户口令
alter user etl identified by etl1234;
9.删除用户命令
drop user etl cascade;
10.删除表空间
drop tablespace etl_temp including contents and datafiles cascade constraints;
//including contents 删除表空间的内容，如果删除表空间之前表空间中有内容，而未加此参数，表空间删不掉
//cascade constraints 同时删除tablespace中表的外键参照
