The RecreateDB script sets parameters and calls scripts to replace an existing HPD Web schema. The current schema is dropped and a new schema is created.
When the RecreateDB script is run, two processes are completed – the DropHPDWebUser script will drop an existing HPD Web schema and the CreateHPDWebUser script recreates the HPD web schema.
1. Open Command Prompt.
2. Navigate to, C:\ProgramData\CARIS\HPD\<version>\Server\HPDWeb
3. Type the script into the command prompt using the following syntax:
cscript RecreateDB.vbs Par1 Par2 Par3 Par4 Par5 Par6 Par7 Par8 Par9 Par10 |
This table lists the abbreviations and the related parameters.
Abbreviation | Parameter |
|---|---|
Par1 | HPD Web system-owner connect string |
Par2 | HPD Web username |
Par3 | HPD Web password |
Par4 | HPD Web tablespace name |
Par5 | HPD Web datafile path and file name |
Par6 | HPD Web tablespace size |
Par7 | HPD Web database name |
Par8 | HPD schema owner username |
Par9 | HPD schema owner password |
Par10 | HPD schema owner database name |
For example:
cscript RecreateDB.vbs system/oracle@WEBdb hpdwebuser hpdwebpass hpdweb D:\oracle\oradata\hpdweb\hpdweb.dbf 1000M WEBdb hpd26user hpd26pass HPDdb |
4. Press <Enter> to run the RecreateDB script.