Creating Tables

As you develop applications in Oracle Life Sciences Data Hub, you can create Oracle LSH Tables in the following ways.

Working in a Work Area, you can:

• Create a Table instance from an existing Table definition
• Create a new Table instance and Table definition manually at the same time
• Create a Table instance and Table definition from an existing SAS data set located in an external system

Working in a Program, Load Set, Data Mart, or Business Area you can:

• Create a Table Descriptor from an existing Table definition
• Create a Table Descriptor and Table definition manually at the same time
• Create a Table Descriptor from an existing SAS data set located in an external system
• Create one or more Table instances from one or more Table Descriptors (using the Actions drop-down list)
• Create one or more Table Descriptors from one or more Table instances (using the Actions drop-down list)

In addition, working in a Load Set you can create a Table Descriptor from a table, data set, or view in an external system.

You can also create a Table definition directly in a Domain or Application Area if you have the necessary privileges. However, you cannot use the definition for storing data until you create an instance of it in a Work Area and install it in the database.