Oracle之create tablespace、user
来源:互联网 发布:微信群淘宝客怎么加入 编辑:程序博客网 时间:2024/06/04 19:16
--创建数据表空间;
create tablespace home_data
datafile 'D:\oracle\oradata\home\home_data.dbf'
size 20m
autoextend on
next 5m
maxsize 50m--或者unlimited
extent MANAGEMENT LOCAL;
--创建索引表空间;以后创建索引时,要制定使用索引表空间;
create tablespace home_index
datafile 'D:\oracle\oradata\home\home_index.dbf'
size 20m
autoextend on
next 5m
maxsize 50m--或者unlimited
extent MANAGEMENT LOCAL;
--创建临时表空间;
create temporary tablespace home_temp
tempfile 'D:\oracle\oradata\home\home_temp.dbf'
size 20m
autoextend on
next 5m
maxsize 50m--unlimited
extent MANAGEMENT LOCAL;
--创建角色;
create role homeuser;
--赋权;
grant create session to homeuser;
grant create table to homeuser;
grant create view to homeuser;
grant create procedure to homeuser;
grant create sequence to homeuser;
--创建用户;
create user home identified by XXXX
default tablespace home_data
temporary tablespace home_temp quota umlimited on home_data;
--给用户赋角色;
grant homeuser to home;
grant unlimited tablespace to home;
create tablespace home_data
datafile 'D:\oracle\oradata\home\home_data.dbf'
size 20m
autoextend on
next 5m
maxsize 50m--或者unlimited
extent MANAGEMENT LOCAL;
--创建索引表空间;以后创建索引时,要制定使用索引表空间;
create tablespace home_index
datafile 'D:\oracle\oradata\home\home_index.dbf'
size 20m
autoextend on
next 5m
maxsize 50m--或者unlimited
extent MANAGEMENT LOCAL;
--创建临时表空间;
create temporary tablespace home_temp
tempfile 'D:\oracle\oradata\home\home_temp.dbf'
size 20m
autoextend on
next 5m
maxsize 50m--unlimited
extent MANAGEMENT LOCAL;
--创建角色;
create role homeuser;
--赋权;
grant create session to homeuser;
grant create table to homeuser;
grant create view to homeuser;
grant create procedure to homeuser;
grant create sequence to homeuser;
--创建用户;
create user home identified by XXXX
default tablespace home_data
temporary tablespace home_temp quota umlimited on home_data;
--给用户赋角色;
grant homeuser to home;
grant unlimited tablespace to home;
- Oracle之create tablespace、user
- Oracle Create TableSpace,User
- Create / Alter Oracle TableSpace / Temporary TableSpace, User...
- oracle create user and create tablespace
- create tablespace user
- oracle create tablespace
- oracle create tablespace
- Create tablespace in Oracle
- oracle create tablespace
- Oracle学习笔记--CREATE TABLESPACE
- oracle raw device create tablespace
- oracle create tablespace参数详解
- oracle create tablespace语法详解
- Oracle Create TableSpace
- Oracle create tablespace语法详解
- Oracle create tablespace语法详解
- oracle create tablespace
- Oracle?create?tablespace语法详解
- 进程间通信 - 命名管道实现
- 【discuz】遇到关于图片的操作就崩了?(如:imagecreatefromjpeg),修改php.ini的内容,把php_gd2.dll前面的;去掉
- 知道笔试结果,很伤心,却是意料之中
- 进程间通信 - 动态链接库实现
- 个人首页不更新
- Oracle之create tablespace、user
- NO.4.JS中一获取tagname的错误
- Android 手势&触摸事件
- HDOJ 1106 排序 (字符串处理)
- Windows 内核(WRK)简介
- img 合并suan Fa
- quartz
- 列举 Windows 所有进程(ToolHelp)
- Skype 去广告安装方法