This topic describes how to create an Oracle table in Data Lake Analytics (DLA).

  1. Log on to the DLA console.
  2. In the left-side navigation pane, choose Serverless Presto > SQL access point. On the SQL access point page, find your virtual private cloud (VPC) and click Log on in DMS in the Actions column to create an Oracle table. This table contains the following information:
eate external table person (
       id int,
       name varchar(1023),
       age int
) tblproperties(
  table_mapping = 'oracle_chema.person'
);