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:
Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.