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

Import a Previously Exported Database Schema

 
Check the HPD Roles
Recreate the Tablespace and HPD Schema Owner Account
Import an Oracle Dump File
Recompile the Imported HPD Schema
Check the Imported HPD Schema
Recreate Missing HPD Schema Users
Gather Database Schema Statistics

This third section explains how to import, that is, restore, an archived (previously exported) schema into an Oracle database. If required, ensure that any old version of the same schema currently in this Oracle database is dropped – see above, and then continue by importing the previously exported schema.