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

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

示例

创建Oracle跨源表

1
2
3
4
5
6
7
8
9
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'
);
support.huaweicloud.com/sqlreference-dli/dli_08_0461.html