CARIS HPD : Database Administration : Exporting and Importing HPD Schemas (Oracle) : Import a Previously Exported Database Schema : Recompile the Imported HPD Schema
 

Recompile the Imported HPD Schema

There may be a few views and functions that need to be recompiled. This can be resolved by executing the HPD Server recompile.sql script. Use the following instructions from a Command Prompt window.

> cd C:\ProgramData\CARIS\HPD\<version>\Server\AdminTools

> sqlplus hpdowner/password@database

SQL> set serveroutput on size 200000
SQL> @recompile

COMPILING PACKAGE SPECIFICATIONS
COMPILING PROCEDURES
COMPILING VIEWS
COMPILING TRIGGERS
COMPILING FUNCTIONS
COMPILING PACKAGE BODYS

PL/SQL procedure successfully completed.

If required, check the version of the HPD schema by running the following SQL statement:

SQL> select version from hpdversion;

VERSION              
--------------------
4.1.2