Creating External Tables

To create an external table in the Oracle Autonomous Database:

1. On the Data Integration home page, from the Actions menu, click Setup and then click Applications.

2. On the Applications page, click Actions and then click Create Table.

3. Select Table Type as External Table.
4. Specify the following:
   • Table Name: Specify a name for the table.
   • Connection: Select the Oracle Autonomous Database source connection.
   • Upload File: Upload the file that has the data. The file will be used to derive the table structure and the table data. If the uploaded file has header, then it uses the header as column names in the table.
   • Delimiter: Select the delimiter used in the file.

     Note:

     The Namespace and Bucket Name fields are automatically populated from the user settings or system settings. If both are available, the user settings take precedence. You can also change these fields to any desired namespace or bucket, including any subdirectories within the bucket.

     The file uploaded in the UI must also be manually copied to the selected namespace and bucket location, including any applicable subdirectories.

5. Click Next and adjust the Column Name, Data Type, Column Length, Date Format, and Is Nullable details, if required.
6. Click Finish.

   A message is displayed indicating the table is created successfully.