Before exporting an HPD database schema, ensure that all database objects, such as procedures, views, functions, etc. for the schema are valid. This is performed by running the CARIS HPD recompile.sql administration script if necessary (see details below). The Oracle export data pump utility exports all objects whether they are valid or invalid, but any invalid objects most likely will not recompile in the new database.
Open a Command Prompt window, and start a SQLplus session, logging into Oracle as the HPD schema owner user account:
> 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.
SQL> exit |