CARIS HPD : Database Administration : Server Upgrade Scripts (Oracle) : Server Upgrade Scripts
 

Server Upgrade Scripts

Before running any script that modifies data, always back up your schemas.

This script must be run using the HPD schema owner account.

Script

Description

upgradeProfileFromENC311ToENC312.sql

Add the attributes listed in IHO S-57 Supplement 2, Circular letter 32/2009.

This can only be reversed by using the HPD Catalogue Editor to manually remove the attributes from the objects listed in that document.

queryduplicateenum.sql

When upgrading from HPD 3.2, the server upgrade checks for enumeration attributes with multiple values. If any are found, the server upgrade will request that this script is run to gather more information. This script only runs on an HPD 3.2 schema.