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.
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.
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.