A GEODESC project is effectively implemented as an Oracle schema. To create a GEODESC project a user will perform the following tasks:
- Create the schema account in Oracle.
- Clone the tables, views, sequences, indexes, etc. from a "base" project (currently the base project is a pre-existing project. In the near future we will create a special-purpose project labeled as "base"). Important: when cloning the base project copy the DDL only, do not copy any data from the source schema)
df Recommendation - store this BASE project in a DMPDP file. Script SQL to load and rename as-needed from the OEMJR:/backup/export/ directory. - Issue the proper grants to resources in the new project.
- Add the newly created GEODESC project to the GEODCAT.PROJECTS table (this will cause it to show up in the "projects" dropdown for GEODESC applications.
- Create new role and associated privilege for the new project.
...