All Products
Search
Document Center

Create a schema

Last Updated: Jul 04, 2020

Syntax

  1. CREATE SCHEMA IF NOT EXISTS test_oracle
  2. WITH DBPROPERTIES (
  3. catalog = 'oracle',
  4. location = 'jdbc:oracle:thin:@//1.2.3.4:1521/XE',
  5. instance = 'HR',
  6. user = 'hello',
  7. password = 'world',
  8. vpc_id = 'vpc_id',
  9. instance_id = 'instance_id'
  10. )
  11. COMMENT '';

Parameters

  • catalog: specifies the schema type as Oracle
  • location: the connection address of the Oracle database
  • instance: the instance name of the Oracle database
  • user: the user name for the Oracle database
  • password: the password corresponding to the user name for the Oracle database
  • vpc_id: the vpcId of the network where the database is located.
  • instance_id: the instanceId of the database or the instanceId of the ECS if the database is installed in ECS.

What to do next

Create a table