Complete list of privs required to create Migration Repository
The documentation is rather poor in this area. Additionally the feedback during repository creation is pathetic. Those who have experienced it know what I'm talking about. I traced multiple repository creation attempts and finally succeded. I believe the following privs are required:
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM (optional)
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE VIEW
Hopefully the developers and tech writers will do a better job next time around.