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;