Check the Imported HPD Schema

Next, run an HPD diagnostic tool to check for errors or invalid objects, missing users and so on:

> sqlplus hpdowner/password@database

SQL> set serveroutput on size unlimited
SQL> exec p_schema_diagnostic.repair;
SQL> select thestring p_schema_diagnostic_results
from table(p_schema_diagnostic.validateHPD);

P_SCHEMA_DIAGNOSTIC_RESULTS
-------------------------------------------------------------------

WARNING: Users missing oracle accounts:
- MANAGER32

INFO: the schema constant is correctly set to HPD410

INFO: SDO_RELATE is working

7 rows selected.

This example indicates that there is a missing Oracle (that is, HPD) user account, which must now be created (see the next section).