Oracle数据库创建/删除用户、创建/删除表空间基本操作

一般创建directory都是为了用数据泵导入/导出数据用，其实directory还有很多别的用处
 
1、新建directory的语法
CREATE [OR REPLACE] DIRECTORY directory AS 'pathname';
 
例如：
create or replace directory dump_dir as 'D:\dump\dir'
这样把目录d:\dump\dir设置成dump_dir代表的directory
 
2、查询有哪些directory
select * from dba_directories
 
3、赋权
grant read,write on directory dump_dir to user01
4、删除
drop directory dump_dir

--创建表空间
--创建主表空间
create tablespace pt6342 datafile 'E:\db\tablespace\oradata\6342\pt6342.dbf' size 50M autoextend on next 50m maxsize 1024m extent management local;
create tablespace pt6316342 datafile 'E:\db\tablespace\oradata\631\pt6316342.dbf' size 50M autoextend on next 50m maxsize 1024m extent management local;
create tablespace dj datafile 'E:\db\tablespace\oradata\630\dj.dbf' size 50M autoextend on next 50m maxsize 1024m extent management local;
create tablespace zf datafile 'D:\db\tablespace\oradata\zf\zf6331.dbf' size 50M autoextend on next 50m maxsize 1024m extent management local;
create tablespace zfoa datafile 'D:\db\tablespace\oradata\zfoa\zfoa.dbf' size 50M autoextend on next 50m maxsize 1024m extent management local;
create tablespace zfoa datafile 'D:\db\tablespace\oradata\zfoa\zfoa.dbf' size 50M autoextend on next 500m maxsize 1024m extent management local;
create tablespace zfoa datafile 'D:\db\tablespace\oradata\zfoa\zfoa.dbf' size 100M autoextend on next 100M maxsize UNLIMITED extent management local;
create tablespace zfoa datafile 'E:\db\tablespace\oradata\zfoa\zfoa.dbf' size 50M autoextend on next 50M maxsize UNLIMITED extent management local;
create tablespace sfyportal datafile 'E:\db\tablespace\oradata\sfyportal\sfyportal.dbf' size 50M autoextend on next 50M maxsize UNLIMITED extent management local;
create tablespace zfoanew datafile 'E:\db\tablespace\oradata\zfoanew\zfoanew.dbf' size 50M autoextend on next 50M maxsize UNLIMITED extent management local;
create tablespace ftzoa datafile 'E:\db\tablespace\oradata\ftzoa\ftzoa.dbf' size 50M autoextend on next 50M maxsize UNLIMITED extent management local;
create tablespace hnzf datafile 'E:\db\tablespace\oradata\hnzf\hnzf.dbf' size 50M autoextend on next 50M maxsize UNLIMITED extent management local;

--创建临时表空间
create temporary tablespace pt6342_temp tempfile 'E:\db\tablespace\oradata\6342\pt6342_temp.dbf' size 50m autoextend on next 50m maxsize 1024m extent management local;
create temporary tablespace pt6316342_temp tempfile 'E:\db\tablespace\oradata\631\pt6316342_temp.dbf' size 50m autoextend on next 50m maxsize 1024m extent management local;
create temporary tablespace dj_temp tempfile 'E:\db\tablespace\oradata\630\dj_temp.dbf' size 50m autoextend on next 5