Use the following guidelines when you set up the warehouse 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.
For more information about configuring the database, see the documentation for your database system.