How to: Create a table explicitly in Target Oracle database for hvr_stats

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #14638
    Pallavik
    Keymaster

    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.

    hvr_stats_scripts_path

    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

    hvr_stats_run_create_Script

    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

    hvr_stats_index_creation

    Step 2: Creating table through SQL developer

    A] Open Sqldeveloper and login to the database that you want to create the table in.

    hvr_stats_login_database

    B] Click on the File button on the top left

    hvr_stats_run_create_from_sqltool

    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

    hvr_stats_index_script_sqltool

    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

    hvr_stats_index_confirmation

     

Viewing 1 post (of 1 total)
  • The forum ‘How to’ is closed to new topics and replies.

© 2020 HVR

Test drive Contact us