Use the following guidelines when you set up the repository on Oracle:
Verify that the database user has the following privileges:
CREATE SESSION
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.