The renameVectorProduct.sql script replaces the name of an existing S-57 product, GML product or Tiled Raster Product with a new name. The Product ID and edition number remain the same. The product that is intended to be renamed should not be active. When the product is renamed, session files that were associated with the renamed product may no longer work.
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>
3. Press <Enter>.
An SQL session is started.
4. To run the script, enter @renameVectorProduct.sql
5. Press <Enter>.
The following prompt is displayed:Enter the name of the existing product:
6. Enter the name of the product that is going to be renamed.
7. Press <Enter>.
The following prompt is displayed:Enter the new name for the product:
8. Enter a name for the new product.
9. Press <Enter>.
The product ID, name and edition are listed.
A prompt, similar to the one below, is also displayed:Script will rename 'OldProductName' to 'NewProductName'.
Do you wish to continue? (Yes/No):
10. Enter Yes to continue, and press <Enter>.
Another prompt asks if you want to continue.
11. Type Yes to continue, and press <Enter>.
A message informs you that the product name has been changed to the new name.