Create / Delete Remedy DB

Create DB:

*Updated for BIGFILE

CREATE BIGFILE TABLESPACE

CREATE BIGFILE TABLESPACE ARSYSTEM DATAFILE '/databases/remedy/ars/arsys.dbf' size 8000M reuse AUTOEXTEND ON;
CREATE BIGFILE TEMPORARY TABLESPACE ARTMP TEMPFILE '/databases/remedy/ars/artmp.dbf' SIZE 2000M REUSE AUTOEXTEND ON;
create user ARAdmin identified by "AR#Admin#" PROFILE "DEFAULT" TEMPORARY TABLESPACE "ARTMP" DEFAULT TABLESPACE "ARSYSTEM" QUOTA UNLIMITED on "ARSYSTEM";
CREATE ROLE ARADMINROLE NOT IDENTIFIED;
GRANT ARADMINROLE TO ARADMIN;
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 ARADMINROLE;

 

Small files:

CREATE TABLESPACE ARSYSTEM DATAFILE '/usr/local/ars_data/ars/ARSYS' size 8000M reuse AUTOEXTEND ON;
CREATE TEMPORARY TABLESPACE ARTMP TEMPFILE '/usr/local/ars_data/ars/ARTMP' SIZE 2000M REUSE AUTOEXTEND ON;
create user ARAdmin identified by "AR#Admin#" PROFILE "DEFAULT" TEMPORARY TABLESPACE "ARTMP" DEFAULT TABLESPACE "ARSYSTEM" QUOTA UNLIMITED on "ARSYSTEM";
CREATE ROLE ARADMINROLE NOT IDENTIFIED;
GRANT ARADMINROLE TO ARADMIN;
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 ARADMINROLE;


Delete AR DB:

drop role aradminrole;
drop user aradmin cascade;
DROP TABLESPACE ARTMP INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE ARSYSTEM INCLUDING CONTENTS AND DATAFILES;

 

***   Note to switch to large files ***

S5 Box

Login