Set up the Topic Workflow database account (optional, installation only)

You create a Topic Workflow tablespace and user account to enable the Oracle Empirica Topics feature.

Note:

Do not perform this procedure if you do not use Oracle 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.

1. Navigate to the /u01/stage/Database directory, for example:
   $ cd /u01/stage/Database
2. Create the topic_workflow database user account:
   1. 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.

   2. Enter the Oracle system account password.

      A second password prompt appears.

   3. Enter a password for the topic_workflow database account.
   4. Reenter the password.
3. Create sample topic tables:
   1. 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.

   2. Enter the topic_workflow account password that you specified in a previous step.
4. Create sample topics:
   1. 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.

   2. Enter the topic_workflow account password that you specified in Step 2.