Table of Contents

Search

  1. About the Test Data Management Installation Guide
  2. Test Data Management Installation Overview
  3. Before You Install TDM
  4. Prepare for Application Services and Databases
  5. Create the Application Services
  6. Install the Clients
  7. TDM Installation
  8. After You Install TDM
  9. Infacmd
  10. Starting and Stopping Informatica and TDM
  11. Uninstallation
  12. Updating the DynamicSections Parameter of a DB2 Database

Installation Guide

Installation Guide

Oracle Database Requirements

Oracle Database Requirements

Use the following guidelines when you set up the repository on Oracle:
  • Set the storage size for the tablespace to a small number to prevent the repository from using an excessive amount of space. Also verify that the default tablespace for the user that owns the repository tables is set to a small size.
    The following example shows how to set the recommended storage parameter for a tablespace named REPOSITORY:
    ALTER TABLESPACE "REPOSITORY" DEFAULT STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLIMITED PCTINCREASE 50 );
    Verify or change the storage parameter for a tablespace before you create the repository.
  • Verify that the database user has the following privileges:

      CREATE SEQUENCE

      CREATE SESSION

      CREATE SYNONYM

      CREATE TABLE

      CREATE VIEW

  • Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.

0 COMMENTS

We’d like to hear from you!