Set up the test data database account

Previous Topic

Next Topic

Book Contents

Set up the test data database account

This procedure is optional.

Perform these steps using the non-privileged user account on the application server.

  1. Navigate to the /u01/stage/Database directory, for example:

    $ cd /u01/stage/Database

  2. Create the TEST_IQOQ database user account and tables:
    1. Execute the 4_create_test_iqoq_oracle_user.sql script as the Oracle system user, for example:

      $ sqlplus system@<TNS_NAME> @4_create_test_iqoq_oracle_user.sql

      A password prompt appears.

    2. Enter the Oracle system account password.

      A second password prompt appears.

    3. Enter a password for the TEST_IQOQ database account.
    4. Reenter the password.

      Note: You use the password in a later step.

  3. Populate the TEST_IQOQ tables:
    1. Execute the 5_populate_test_iqoq.sql script as the test_iqoq database user, for example:

      $ sqlplus TEST_IQOQ@<TNS_NAME> @5_populate_test_iqoq.sql

      A password prompt appears.

    2. Enter the TEST_IQOQ database account password.
Send Feedback