Creating the Contenta tablespaces

Perform these steps to create Contenta tablespaces.

Procedure

  1. Create one or more directories for Contenta tablespaces.

    Make sure that the hard drives that contain the tablespaces have sufficient space for your site’s needs—enough space to contain the .dbf files.

    SDL recommends that you create each tablespace on separate disks to minimize the load.

  2. Edit the pdm_setup.sql script installed in the Contenta_home\setup directory on the server.
    To identify the lines to edit, see the example below. You can modify:
    • Path name to each of the tablespaces (to the appropriate directory or directories created in Step 1)
    • Size of each tablespace

      The samples include recommended sizes but you must define the tablespace size to meet your site needs. For example: datafile 'D:\oracle\pdm_1.dbf' SIZE 2000M

  3. Execute the script:
    1. At a command prompt on the server, go to the
      Contenta_home\OracleScripts directory.
    2. At the command prompt enter:
      sql_pathname\sqlplus
      where sql_pathname is the directory where the sqlplus.exe file is located.
    3. Enter the default Oracle user (system) and password (as specified during the Oracle Server installation).
    4. At the prompt, enter:
      @pdm_setup.sql
      where pdm_setup.sql is the SQL script that defines the Contenta tablespaces.

    SQLplus displays a series of messages either confirming that the tablespaces were created, or providing error information for you to correct the script.

    The following PdmScript is an example only. It shows how you can define the tablespaces. The data you modify for your site is highlighted in bold. Note that this file specifies the D: drive for storage.

    Your site and configuration may require more or less space. You should monitor tablespace daily to ensure the operations have sufficient space to complete properly.
    -- Run this script as the oracle user (system/"passwd")
    -- the sizes and paths can be changed as needed based om site req's
    create tablespace pdm_appl_data
    datafile 'D:\oracle\pdm_1.dbf' SIZE 2000M
    default storage (
    minextents 1 maxextents unlimited
    pctincrease 1)
    online
    permanent;
    alter tablespace pdm_appl_data add datafile 'D:\oracle\pdm_2.dbf' SIZE 2000M;
    create tablespace pdm_indx_data
    datafile 'D:\oracle\pdmindx_1.dbf' size 1000M
    default storage (
    minextents 1 maxextents unlimited
    pctincrease 1)
    online
    permanent;
    create temporary tablespace pdm_temp
    tempfile 'D:\oracle\temp_1.dbf' size 500M;
    create user xyadmin identified by manager
    default tablespace pdm_appl_data temporary tablespace pdm_temp;
    alter user xyadmin quota unlimited on pdm_appl_data;
    alter user xyadmin quota unlimited on pdm_indx_data;
    grant connect to xyadmin;
    grant create user to xyadmin;
    grant alter user to xyadmin;
    grant drop user to xyadmin;
    grant grant any privilege to xyadmin;
    grant select any dictionary to xyadmin;
    create table xyadmin.pdm_databases
    (
    username char(50),
    userid integer,
    index_tablespace char(50)
    );
    connect xyadmin/manager;
    grant select on xyadmin.pdm_databases to public;
    Exit