CARIS HPD : Database Administration : Exporting and Importing HPD Schemas (Oracle) : Import a Previously Exported Database Schema : Recreate Missing HPD Schema Users
 

Recreate Missing HPD Schema Users

If missing users are reported by the HPD diagnostic procedure (see above), run the follow HPD scripts as well, recreateloginusers.sql and restore_all_synonyms.sql:

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

> sqlplus hpdowner/password@database

SQL> set serveroutput on size unlimited

SQL> @recreateloginusers

Warning Hpd_existing_user already exists.
User Hpd_missing_user1 created.
User Hpd_missing_user2 created.

...

PL/SQL procedure successfully completed.

SQL> @restore_all_synonyms

PL/SQL procedure successfully completed.