- 论坛徽章:
- 0
|
原帖由 zhengyi158 于 2009-3-2 16:39 发表 ![]()
建立表空间
1.表空间名称为:test
2.临时表空间名称为:test_TMP
建立帐号
1.建立帐号:test3,密码:test3
帐号使用的表空间如下:
1.缺省表空间(Default tablespace): test
2.临时表空间(T ...
oracle9i下:
sqlplus system/system_pass@conn_str <<EOF
create tablespace test
datafile '/oradata/test.dbf' size 30M reuse
extent management local
segment space management auto;
create temporary tablespace test_tmp
TEMPFILE
'/oradata/test_tmp.dbf' size 1020M reuse
EXTENT MANAGEMENT LOCAL;
create user test3 identified by test3
default tablespace test
temporary tablespace test_tmp
quota unlimited on test
quota unlimited on test_tmp;
grant connect,resource to test3;
exit
EOF |
|