Oracle Database Creation Script

If your account on the Meridian Enterprise Server server does not have sufficient privileges to create a new database on the database server as described in Create a Meridian Explorer Repository, you can create a Meridian Explorer repository database or a Meridian Enterprise Server configuration database with the following script.

Create a Meridian Explorer Repository Database

To create a Meridian Explorer repository database or a Meridian Enterprise Server configuration database on the database server:

1. In SQLPlus, run the following PL-SQL script.

2. Change <UserName> and <Password> to the desired user name and password respectively.

DEFINE UserName = "<UserName>"
DEFINE Password = "<Password>"
--------------------------------------------------------------------------------
CREATE USER &UserName IDENTIFIED BY &Password 
ACCOUNT UNLOCK 
– DEFAULT TABLESPACE "USERS" 
– TEMPORARY TABLESPACE "TEMP" 
– PROFILE "DEFAULT";
GRANT RESOURCE, CREATE SESSION TO &UserName; – required for Oracle 11(nnk)
GRANT RESOURCE, CONNECT TO &UserName;
GRANT EXECUTE ON CTX_DDL TO &UserName;
GRANT CREATE VIEW TO &UserName;
GRANT ALTER ANY TABLE TO &UserName; 
GRANT CREATE PROCEDURE TO &UserName;
GRANT CREATE TRIGGER TO &UserName;
GRANT CREATE UNLIMITED TABLESPACE TO &UserName;
– ALTER USER &UserName QUOTA 100M ON USERS;
--GRANT EXECUTE ON "CTXSYS"."CTX_DDL" TO "&UserName";