ORACLE创建用户并指定默认表空和默认临时表空间 //创建临时表空间 create temporary tablespace bocodbtempdbs tempfile 'D:\oracle\oradata\bocodb\bocodata\bocodbtempdbs01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; //创建数据表空间 create tablespace bocodbdbs logging datafile 'D:\oracle\oradata\bocodb\bocodata\bocodbdbs.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; //创建用户并指定表空间 create user bocodb identified by bocodb default tablespace bocodbdbs temporary tablespace bocodbtempdbs; //给用户授予权限 grant connect,resource to bocodb; |