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 will remain the same. The product that is intended to be renamed should not be active. 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.
2. Start an SQL session as a schema owner: sqlplus <schema_owner>/<password>@<database>
3. Press <Enter>.
An SQL session is started.
4. To run the script, type @renameVectorProduct.sql
5. Press <Enter>.
The following prompt is displayed:
Enter the name of the existing product:
6. Type 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. Type 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. Type Yes to continue and press <Enter>.
Another prompt asks if you want to continue.
11. Type Yes to continue and press <Enter>
A message is displayed, informing you that the product name has been changed to the new name.