oracle 创建表空间用户
1、创建普通表空间和用户
//创建临时表空间
create temporary tablespace oa_temp
tempfile 'D:\app\Administrator\oradata\orcldjoa_temp.dbf'
size 32m
autoextend on
next 32m maxsize 20480m
extent management local;
//创建数据表空间
create tablespace oa
logging
datafile 'D:\app\Administrator\oradata\orcldjoa.dbf'
size 32m
autoextend on
next 32m maxsize 20480m
extent management local;
//创建用户
create user oa identified by oa
default tablespace oa
temporary tablespace oa_temp;
//给用户添加权限
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO oa
drop user oa cascade;
drop tablespace oa including contents and datafiles;
drop tablespace oa_temp including contents and datafiles;
2、创建大表空间和用户
//创建临时表空间
create bigfile temporary tablespace sxybyj_temp
tempfile 'E:\app\Administrator\oradata\orcl\sxybyj_temp.dbf'
size 128m
autoextend on
extent management local
uniform size 128k
//创建数据表空间
create bigfile tablespace sxybyj
datafile 'E:\app\Administrator\oradata\orcl\sxybyj.dbf'
size 128m
autoextend on
extent management local
uniform size 128k
//创建用户
create user sxybyj identified by sxybyj
default tablespace sxybyj
temporary tablespace sxybyj_temp;
//给用户添加权限
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO sxybyj
drop user sxybyj cascade;
drop user test1 cascade;
drop tablespace sxybyj including contents and datafiles;
drop tablespace sxybyj_temp including contents and datafiles;
最新文章
- java Fn键
- HttpContext.GetOwinContext().Authentication 报错 解决办法
- 第一章 JacksonUtil 序列化与反序列化属性总结
- 创建第一个ArcGIS API for Silverlight应用
- bootstrap学习笔记<;三>;(文本,代码域,列表)
- OQL对象查询语言
- hdoj 2063 过山车【匈牙利算法+邻接矩阵or邻接表】
- Windows Message Queue(优先队列)
- uva 10548 - Find the Right Changes(拓展欧几里得)
- stack around the variable “ ” was corrupted
- HDU 2516 取石子游戏 斐波纳契博弈
- runtime关联属性示例
- C/C++中const关键字的用法及其与宏常量的比较
- PL/SQL 存储过程
- P2049 魔术棋子
- GC知识随笔
- 详解MathType中如何插入特殊符号
- C# 4.0中的动态类型和动态编程
- Java异常封装
- [洛谷P4609] [FJOI2016]建筑师
热门文章
- Java之Ajax技术
- php 配置本地自定义域名
- 文件传输基础——Java IO流
- Demo3使用bootstrap
- linux普通用户权限设置为超级用户权限方法、sudo不用登陆密码
- iOS -Swift 3.0 -UILabel属性大全
- django url 软编码
- 实验10.3_数值显示拓展_dword型数转变为表示十进制数的字符串
- PostgreSQL 中日期类型转换与变量使用及相关问题
- JSon_零基础_008_将JSon格式的";数组";字符串转换为List集合