Overview

GEODESC projects are represented by Oracle schemas--one schema per project. This schema consists of tables, indexes, triggers and sequences.  Creating this project infrastructure consists of the following steps.

  1. Create the Oracle schema-owner account (with preferred storage settings).
    1. Method--SQL Developer GUI.
    2. Method--Script.
  2. Apply Oracle DDL for the schema.
    1. Method 1--SQL Developer > Tools > copy DDL from an existing GEODESC project to the new schema-owner.
    2. Method 2--run a DDL script to do the same.
  3. Issue the appropriate grants for each table in the schema.
  4. Register the new project in the GEODCAT.PROJECTS table.
  5. Establish AUTHER permissions for the new GEODESC project.

The child pages of this document detail the GUI and script methods. The GUI method uses the facilities of Oracle SQL Developer. The command-line method is annotated for operation from a SQL Developer worksheet.

Pre-requisites

These processes require tools to connect to the Oracle database. Oracle's SQLcl, SQL Developer, SQL*PLUS all may be used to accomplish these activities.

The tools are known to be installed on BUILD (HQ & JR) and on shipboard DEV (asset 54198 Z2). Since we are using AD logins, ensure your account is configured to use the tools you prefer.

Existing configuration for SQL Developer may be copied (from \\novarupta\dml\software\tools\oracle\sqldeveloper\AppData\Roaming) and adapted for local use.




  • No labels