数据湖探索 DLI-创建DLI表关联Oracle:示例

时间：2024-07-01 21:07:48

数据湖探索 DLI 跨源连接Oracle表

示例

创建Oracle跨源表

  
       CREATE TABLE IF NOT EXISTS oracleTest
  USING ORACLE OPTIONS (
  'url'='jdbc:oracle:thin:@//192.168.168.40:1521/helowin',
  'driver'='oracle.jdbc.driver.OracleDriver',
  'dbtable'='test.Student',
  'user' = 'test',
  'password' = 'test',
  'resource' = 'obs://rest-authinfo/tools/oracle/driver/ojdbc6.jar'
);