Documentation Center

Creating the Oracle tablespaces in the database

You must create tables and related database files for the Contenta environment in your Oracle database.

Procedure

  1. Log in as the root user.
  2. Edit the /pdm/setup/pdm_setup.sql script.
  3. Find the section of the file that reads:

    The sizes in the pdm_setup.sql file, as delivered, are suggested configuration sizes for a typical database.

    Create the tablespace file path under Oracle_home. This is because default Oracle users (like sys and system) do not have permissions to create or access files anywhere other than Oracle_home
  4. Edit the entries for the other tablespaces. The other tablespace entries in the file are:
    datafile '/usr/app/pdmqa/pdmdbs/pdmindx_1.dbf' size 1000M
    datafile '/usr/app/pdmqa/pdmdbs/temp_1.dbf' size 500M
  5. Check that the tablespace directories are owned by oracle and the group is dba.
  6. Source the /pdm/bin/pdm.cshrc file.
  7. At a system prompt, change the directory by entering cd /pdm/setup.
  8. Execute the pdm_setup.sql script in SQL*Plus.

    At a system prompt, enter:

    sqlplus system/pword

    where pword is the user’s password.

  9. At the SQL*Plus prompt, enter: @pdm_setup.sql

    This creates the Contenta tablespaces, rollback segments, and data files.

  10. When the script is completed, at the SQL*Plus prompt, enter exit.