Set up the Topic Workflow database account (optional, installation only)
You create a Topic Workflow tablespace and user account to enable the Empirica Topics feature. Do not perform this procedure if you do not use Empirica Topics.
For more information, see the User Guide and Online Help.
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 topic_workflow database user account:
- Start SQL*PLUS.
- Execute the create_topics_oracle_user.sql script as the Oracle system user, for example:
$ sqlplus system@<TNS_NAME> @create_topics_oracle_user.sql
A password prompt appears.
- Enter the Oracle system account password.
A second password prompt appears.
- Enter a password for the topic_workflow database account.
- Reenter the password.
Note: You use the password in a later step.
- Create sample topic tables:
- Execute the create_sample_topics_tables.sql script as the topic_workflow database user, for example:
$ sqlplus topic_workflow@<TNS_NAME> @create_sample_topics_tables.sql
A password prompt appears.
- Enter the topic_workflow account password that you specified in a previous step.
- Execute the create_sample_topics_tables.sql script as the topic_workflow database user, for example:
- Create sample topics:
- Execute the populate_sample_topics_tables.sql script as the topic_workflow database user, for example:
$ sqlplus topic_workflow@<TNS_name> @populate_sample_topics_tables.sql
You are prompted to enter a password.
- Enter the topic_workflow account password that you specified in step 2.
- Execute the populate_sample_topics_tables.sql script as the topic_workflow database user, for example: