ORACLE创建用户并指定默认表空和默认临时表空间

 

create temporary tablespace nicadbtempdbs tempfile '$FILE_PATH/nicadbtempdbs_1.dbf'  SIZE   4000M  EXTENT MANAGEMENT LOCAL ; 
CREATE TABLESPACE  nicadbs  DATAFILE '$FILE_PATH/nicadbs_1.dbf'  SIZE   20000M  EXTENT MANAGEMENT LOCAL AUTOALLOCATE segment space management auto; 

 

--create user rcalcdb

create user rcalcdb identified by rcalcoptr
default tablespace rcalcdbs
temporary tablespace rcalcdbtempdbs;

--grant role

grant connect,resource to rcalcdb;
grant unlimited tablespace to rcalcdb;