This topic is an overview of the process to export an HPD schema from an Oracle database, how to delete it from a database, and how to import it at a later date. Exports are a fast way to make a copy of your HPD schema if you need to share it. They also provide a way of creating a copy of your HPD schema in a server that is separate from your production database, for testing or acceptance activities.
This note relates to Oracle 12c databases, and to CARIS HPD version 4.0 and later. It is important that each organization review their business requirements for backing up an Oracle database. Although Oracle’s "Export Data Pump" (expdp) and "Import Data Pump" (impdp) utilities described here provide a quick way to back up the contents of an HPD database schema, e.g., to share this data with CARIS Customer Services, they have many limitations and a tool such as Oracle Recovery Manager (RMAN) would be a better way to manage a backup strategy. Refer to Oracle’s Administration Manuals for more detailed information (available online): - For Oracle 12c Release 2: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/index.html Note also that some version interoperability problems may occur when using 11g import/export utilities with an Oracle 12c database. Please refer to Oracle compatibility matrix in the Oracle Support Note 553337.1 for more details. |
Re: Oracle’s Support Note 553337.1 Export client compatibility: Always use a version of the Export utility that is equal to the lowest version of either the source or the target database. Import client compatibility: Always use a version of the Import utility that is equal to the version of the target database. |