The CopyPaperChart.sql script creates an identical version of an existing chart. The new chart includes all metadata (edition number, version number, chart status, etc.) from the original. All cartographic and hydrographic features along with attributes are also copied. The chart is given a new name while the script is run.
1. In a Command Prompt, navigate to C:\ProgramData\CARIS\HPD\<version>\Server\admintools\edit.
2. Start an SQL session as the schema owner: sqlplus <schema_owner>/<password>@<database>
An SQL session is started.
3. To run the script, enter @copyPaperChart.sql
4. Press <Enter>.
The following message is displayed.
========================================================================= copyPaperChart ========================================================================= This script copies a chart. The new chart is not related to the original. Only the latest version of a chart can be copied. =========================================================================
LOG ---------------------------------------------------------- copyPaperChart_20120501-163416.log
ID NAME VER ------ ------------------------------------- --- 21 MyChart 1.0 81 MyChart290412 1.0 102 MyChart010512 1.0 Enter the ID of the chart to copy: |
5. Enter the chart ID number and press <Enter>.
You are prompted to type a new name for the chart.
6. Enter the name., and press <Enter>.
A message such as the following asks if you wish to continue.
Enter the new title of the chart: MyChart010512B Do you wish to continue? (Yes/No): Yes |
7. Enter Yes (or Y) to continue, or anything else to cancel.
8. Press <Enter>.