CARIS HPD : Database Administration : Creating and Setting Up a New HPD Schema : Creating a Schema
 

Creating a Schema

 
New PostgreSQL Schema Using Server Utility
New Oracle Schema Using HPD Server Utility

This section explains how to create a new HPD schema.

To create a new schema or update an existing schema, use the HPD Server Utility.

To upgrade an existing schema, see Upgrading a Schema.

When creating an HPD schema for Oracle, you must know the locations of the database server and database data files. A new schema starts with 400 MB of tablespace. Large amounts of data require that ample tablespace be available.

To ensure data safety, back up your schemas at regular intervals.

Oracle and PostgreSQL handle passwords differently. See Changing Passwords – Functionality for more information.