//创建数据表空间
create tablespace sam
logging
datafile 'C:oracleproduct10.2.0oradataorasam01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

create tablespace juddi
logging
datafile 'C:oracleproduct10.2.0oradataorajuddi01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建用户并指定表空间
create user sysadmin identified by sysadmin
default tablespace sam;

//给用户授予权限

grant connect,resource to sysadmin;

分别在oracle中创建表空间sam，及juddi
alter   user   sysadmin   quota   100m   on   juddi;  
alter   user   sysadmin quota   50M   on   sam quota   50M   on juddi;