Table of Contents

Search

  1. Preface
  2. Content Installation
  3. Configuration Steps for Address Reference Data
  4. Appendix A: Address Validator Transformation Advanced Properties

Oracle Database Requirements

Oracle Database Requirements

Use the following guidelines when you set up the repository on Oracle:
  • Verify that the database user has the following privileges:

      ALTER SEQUENCE

      ALTER TABLE

      CREATE SEQUENCE

      CREATE SESSION

      CREATE TABLE

      CREATE VIEW

      DROP SEQUENCE

      DROP TABLE

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


Updated August 04, 2020