Oracle URI format

URI definition for Oracle follows this standard:

Identifier fragments:

• Namespace: oracle://{host}:{port}
  • Scheme = oracle
  • Authority = {host}:{port}
• Unique name: {database}.{schema}.{table}

URI format:

• oracle://{host}:{port}/{database}.{schema}.{table}

Parameters limitations:

• host identifier must start with a lowercase letter and include only lowercase letters, numbers, dash and dot (regex: [a-z][a-z0-9-.]+)
• port number must include only numbers
• database name must start by a letter and include only lowercase and uppercase letters, numbers, underscore, dollar and # (Regex: [a-zA-Z][a-zA-Z0-9_$#]*). This parameter should match the DB_UNIQUE_NAME parameter you can find in Oracle.
• schema and table can have two format, following Oracle naming standards: quoted format and unquoted format
  • unquoted identifier must include only lowercases, uppercases, numbers and underscore, dollar and # (regex:[a-zA-Z][a-zA-Z0-9_$#]* )
  • quoted identifier needs to be quoted using double quotes “ and must include only characters included in the unicode range U+0001 to U+007F, excluding double-quote character.

Examples:

• oracle://sifflet-dev-oracle.bu2ngc.eu-west-1.rds.amazonaws.com:1521/database_name.schema.table_name
• oracle://sifflet-dev-oracle.a2ngc.eu-west-1.rds:1521/data$ba_se."{SCh1234^_$#A"."tABle1234_?$#my]_"