Oracle创建表空间并赋权
[日期:2011-12-06] 来源:Linux社区 作者:yaerfeng
Oracle创建表空间并赋权
SQL>
create tablespace stu_data
datafile 'E:\G3T05\oracle\t1\stu_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
Tablespace created
SQL>
SQL>
create temporary tablespace stu_temp
tempfile 'E:\G3T05\oracle\t1\stu_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
SQL>
create user tudou identified by "111"
default tablespace stu_data
temporary tablespace stu_temp;
User created
SQL> grant connect,resource to tudou;
本篇文章来源于 Linux公社网站() 原文链接:
阅读(857) | 评论(0) | 转发(2) |