To add a multi-tenant table to a connected OpenEdge database using the schema wizard:

  1. Click Add table . The Add table icon is on the context menu when either the TABLE node or an individual table node is selected in the OpenEdge DB Structure view. It is also available as a toolbar icon on the OpenEdge Table tab of the Oracle DB Details view.
  2. Type a unique name in the Table Name field.
  3. Select the Multi-tenant check box.
    Note: The Multi-tenant check box is unchecked and disabled when you try to add a table for database that is not enabled for multitenancy; it is unchecked and enabled when you try to add a shared table.
  4. To associate the multi-tenant table with a storage area:
    1. Select the Support default tenant check box (if it is not already selected) to enable the Area field.
    2. Select a storage area from the drop-down list at the Area field.
      Note: The Support default tenant option is automatically selected when you select the Multi-tenant check box. When you clear the Support default tenant check box, the Area field gets disabled.
  5. Type a unique name in the Dump File field. This name can be up to 32 characters in length.
  6. Optionally enter information in the Label, Description, Validation, and Message fields. See OpenEdge Table wizard for more information about these fields and other options available on the wizard.
  7. Select Next to open the OpenEdge Columns wizard.You must add at least one column to the table. The Add Columns dialog allows you to either copy columns from other tables or create a new column.
    Note: When you copy a column, you copy only the column schema. You do not copy data.
  8. Select Next to Add OpenEdge database indexes or Finish to complete the table and add it to the database.
    Note: Since tables are displayed in ASCII order and sorting is case-sensitive, all lowercase table names are listed after the uppercase table names.