1. Guide
  2. Using Oracle Spatial Studio
  3. Spatial Studio Datasets Page
  4. About Creating a Dataset From the Datasets Page
  5. Creating a Dataset from Database Tables or Views

3.6.1.1 Creating a Dataset from Database Tables or Views

Using a database connection, you can create a dataset from tables and views in the Oracle Database.

Perform the following steps to create a dataset using a database connection:
  1. Navigate to the Datasets page.
  2. Click Create Dataset.
    The Create Dataset window opens.
  3. Select the Database table/view option.
  4. Select a connection from the Select Connection drop-down.
  5. Click Create.

    The Select items to create datasets window opens listing all the tables, views and GeoRaster data present in the database.

    Figure 3-9 Select the Data Source

    Description of Figure 3-9 follows
    Description of "Figure 3-9 Select the Data Source"
  6. Select a database item from the list and click OK.

    Tip:

    You can also use the Search box to quickly locate your table. This is especially useful or even necessary if your database connection has many tables, as the drop-down list only shows up to 500 tables or views.

    The new dataset is added and listed on the Datasets page.

Parent topic: About Creating a Dataset From the Datasets Page