Setting up the test data database account (installation only)

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. If the TEST_IQOQ database account exists, drop the account:
   1. Start SQL*PLUS.
   2. Execute the drop user command as the system user, for example:

      $ sqlplus system@<TNS_NAME>

      A password prompt appears.

   3. Type the Oracle system account password.

      SQL> drop user TEST_IQOQ cascade;

   4. Exit SQL*PLUS.
3. 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. Type the Oracle system account password.

      A second password prompt appears.

   3. Type a password for the TEST_IQOQ database account.
   4. Retype the password.

      Note: You use the password in a later step.

4. 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. Type the TEST_IQOQ database account password.

Copyright © 2002, 2017 Oracle and/or its affiliates. All rights reserved.