Configuring a database on Oracle - 8.0

Talend Data Catalog Installation and Upgrade Guide

Version
8.0
Language
English
Operating system
Linux
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Catalog
Content
Installation and Upgrade
Last publication date
2024-01-26

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 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;