Configuring a database on Oracle - 7.3

Talend Data Catalog Installation and Upgrade Guide for Windows

author
Talend Documentation Team
EnrichVersion
7.3
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Installation and Upgrade
EnrichPlatform
Talend Data Catalog

Before you begin

Make sure the database you are using meet the requirements described in Compatible databases.

Procedure

  1. Log in to an existing database.
    sqlplus.exe SYS@<DB-NAME> as SYSDBA
  2. Create a user MM and a database MM with the following privileges.
    -- Delete previous user and database if needed
        DROP USER MM CASCADE;
        CREATE USER MM IDENTIFIED BY MM123!;
    
        GRANT CONNECT TO MM;
        GRANT CREATE TABLE TO MM;
        GRANT CREATE VIEW TO MM;
        GRANT CREATE SEQUENCE TO MM;
        GRANT CREATE TRIGGER TO MM;
        GRANT CREATE PROCEDURE TO MM;
        GRANT CREATE TYPE TO MM;
        GRANT EXECUTE ON DBMS_LOB TO MM;
    
    -- If you get the error "Database exception occurred: ORA-01950: no privileges on tablespace 'USERS'"
        ALTER USER MM QUOTA UNLIMITED ON USERS;