oracle创建默认表和临时表空间
- 2017-11-13 15:50:00
- admin 原创
- 2353
1. 创建临时表空间
SQL> create temporary tablespace test1temp
tempfile '/home/u01/app/oracle/oradata/ytzx/test1temp01.dbf'
size 10240m
autoextend on next 1024m
maxsize 20480m
extent management local ;
2. 创建数据表空间
SQL> create tablespace test1
logging
datafile '/home/u01/app/oracle/oradata/ytzx/test1.dbf'
size 10240M --50-100G
autoextend on next 2000M
maxsize unlimited
extent management local autoallocate
segment space management auto ;
3.创建用户并制定临时表空间和默认表空间
SQL>create user test1 identified by test1
default tablespace test1
temporary tablespace test1temp;
4.给用户授予权限
grant connect,resource to test;
发表评论
文章分类
联系方式
联系人: | 郑州-小万 |
---|---|
电话: | 13803993919 |
Email: | 1027060531@qq.com |
QQ: | 1027060531 |
网址: | www.wanhejia.com |
Update Required
To play the media you will need to either update your browser to a recent version or update your Flash plugin.