Oracle database

Structure

Server (instance) → Database → User=Schema → Tables/Objects

• Database: In Oracle, the "database" is the entire system of data files, control files, redo logs, etc. A database is tied to an instance (set of processes + memory structures). Usually, one instance ↔ one database, though RAC can have multiple instances for one database.

• Schema: In Oracle, a schema is essentially a user account.

  When you create a user (CREATE USER foo IDENTIFIED BY ...), Oracle automatically creates a schema with the same name. That schema contains all objects owned by that user (tables, views, procedures, etc.).

  There isn’t a concept of multiple schemas under one user; it’s a 1:1 mapping (user = schema).

  It is possible to query another user's objects (cross-schema access) if you have the permissions

Telosys typical configuration for Oracle database

  - id: oracle
    name: Oracle database
    type: oracle 
    # JDBC driver 
    driver: oracle.jdbc.OracleDriver
    # JDBC connection
    #   url for SID:     jdbc:oracle:thin:@[HOST][:PORT]:SID     (older format)
    #   url for SERVICE: jdbc:oracle:thin:@[HOST][:PORT]/SERVICE (newer format)
    url: jdbc:oracle:thin:@localhost:1521/MYDBSERVICE
    user: SCOTT
    password: TIGER
    # Metadata parameters
    catalog: '!'
    schema: MYSCHEMA
    tableNamePattern: '%'
    tableNameInclude:
    tableNameExclude:
    tableTypes: TABLE

JDBC driver

Download from https://www.oracle.com/fr/database/technologies/appdev/jdbc-downloads.html

JAR for Oracle versions 21c, 19c, 18c, and 12.2:

• ojdbc11.jar ( JDBC 4.3 / JDK11 and JDK17 )

• ojdbc10.jar ( JDBC 4.3 / JDK11 )

• ojdbc8.jar ( JDBC 4.2 / JDK8 and JDK11 )