How to: Create a table explicitly in Target Oracle database for hvr_stats
Scenario:
HVR GUI allows to create a statistics channel which can help user to view the summary of integrates, updates or deletes happened on a particular channel. This also allows to see changes to a particular table in a channel. The table named hvr_stats is populated with the summary for the channels using the hvr.out file as an input.
Overview:
We have made the creation of this table easier for customer by providing them the scripts which is located in the directory $HVR_HOME/demo/hvr_stats/oracle. The scripts that we use are 'hvr_stats.cre' and 'hvr_stats.mod'
This article describes how to explicitly create the table hvr_stats in Oracle database
1) Using command line
2) Using SQL developer
Steps:
Step 1: For creating the table using command line
A] Navigate to the path where the scripts hvr_stats.cre and hvr_stats.mod are located.
B] Run script hvr_stats.cre using below commands
$ sqlplus <username>/<password> < hvr_stats.cre
Here the username and password is to connect to the database
C] Run script hvr_stats.mod to create indexes
$ sqlplus <username>/<password> < hvr_stats.mod
Here the username and password is to connect to the database
Step 2: Creating table through SQL developer
A] Open Sqldeveloper and login to the database that you want to create the table in.
B] Click on the File button on the top left
C] Open the directory where the script hvr_stats.cre is located which is $hvr_home/demo/hvr_stats/base/oracle. Import this script and execute it. You should see a table hvr_stats created
D] Similarly Open the directory where the script hvr_stats.mod is located which is $hvr_home/demo/hvr_stats/base/oracle. Import this script and execute it. You should see indexes created for this table
