Oracle

About this task

Run the following CREATE commands to create tables spaces that are used for the ODF system tables when using Oracle.

Procedure

  1. Modify the sample CREATE command to create the table spaces listed. The CREATE command must be run multiple times, once for each of the table spaces names. The example shows the CREATE command for the first table space in the list.
  2. Submit the job to run the CREATE commands.
  3. Check the completion status to confirm that the table spaces were created successfully.

Example

Use the following sample to create each of the table spaces listed. For example, to create the table space for table ARSDFBDT:

                                                               
# sqlplus "userid/password@db_name" 
                                                              
CREATE TABLESPACE ARSDFBDT DATAFILE 'ARSDFBDT_TS.dbf' SIZE 1M   
      AUTOEXTEND ON MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Use the sample to create these table spaces:

  • ARSDFBDT
  • ARSDFDCT
  • ARSDFDRT
  • ARSDFDST
  • ARSDFLIS
  • ARSDFPPT
  • ARSDFUOT
  • ARSDFCRT
  • ARSDFEML

Verify or replace the following parameters in the CREATE command example:

userid
The Content Manager OnDemand instance owner.
password
The Oracle database password of the instance owner.
db_name
The Content Manager OnDemand Oracle database name.