Schemas can be copied to Oracle export files (*.dmp) using the HPD data pump. The data pump exports only the selected product and associated source data to the file and ignores other data in the schema. See HPD Data Pump for more information.
Two scripts are available for exporting HPD data:
• exportProduct.sql for S-57 products
• exportPaperChart.sql for paper charts
1. In Command Prompt, navigate to C:\ProgramData\CARIS\HPD\<version>\Server\admintools.
2. Start an SQL session as a schema owner.
3. Open a script by typing one of the following:
• @exportProduct.sql
• @exportPaperChart.sql
4. Press <Enter>.
The following message is displayed, depending on the script you are running:
• For S-57 products: Enter the ID of the product to export:
• For paper charts: Enter the version ID of the chart to export:
5. Type the ID of the S-57 product or paper chart.
6. Press <Enter>.
The HPD data pump is activated and the product is exported to an Oracle export file.