Creating Standard Tables

To create a standard 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 Standard 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 will be used to derive the table structure. The data must be loaded to the table separately. 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 disabled.

5. Click Next and adjust Data Type and Data Length, if required.
6. Click Finish.

   A message is displayed indicating the table is created successfully.