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.
Important!
Do not attempt to use this script to create a Meridian Enterprise vault database. The database structure of vaults is different.
Create a Meridian Explorer Repository Database
To create a Meridian Explorer repository database or a Meridian Enterprise Server configuration database on the database server:
-
In SQLPlus, run the following PL-SQL script.
-
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";