Set up the test data database account
This procedure is optional.
Perform these steps using the non-privileged user account on the application server.
- Navigate to the /u01/stage/Database directory, for example:
$ cd /u01/stage/Database
- Create the TEST_IQOQ database user account and tables:
- 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.
- Enter the Oracle system account password.
A second password prompt appears.
- Enter a password for the TEST_IQOQ database account.
- Reenter the password.
Note: You use the password in a later step.
- Execute the 4_create_test_iqoq_oracle_user.sql script as the Oracle system user, for example:
- Populate the TEST_IQOQ tables:
- 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.
- Enter the TEST_IQOQ database account password.
- Execute the 5_populate_test_iqoq.sql script as the test_iqoq database user, for example: