全部博文
-
编辑 删除
创建数据表空间
//创建数据表空间 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;  
