Pre-creating an Oracle tablespace for BMC Remedy AR System - Cloud Database

Create temporary tablespace CARTEMP

  TempFile '/data1/oracle/oradata/ora11db/ctemp01.tmp' SIZE 1024M
  Extent management local uniform SIZE 16M;

create tablespace CARSystem
  datafile '/data1/oracle/oradata/ora11db/CARSys.dbf'
 size 2000M reuse;

create user CARAdmin identified by AR#Admin#
 default tablespace  CARSystem temporary tablespace CARTEMP
  quota unlimited on CARSystem;

create role CARole_arsys not identified;

grant alter session, create cluster, create database link, create  sequence,
 create session, create synonym, create table, create view, create procedure,
 create trigger, query rewrite to CARole_arsys;

grant CARole_arsys to CARAdmin;