//创建表空间

create temporary tablespace test
tempfile 'D:\ACCP5.0\Oracle\oradata\orcl\freedom'
size 5m
extent management local;

//创建用户并指定表空间

create user freedom identified by freedom
temporary tablespace test;

//给用户授予权限
grant connect,resource to freedom;

posted on 2009-10-03 01:06  freedom831215  阅读(206)  评论(0)    收藏  举报