Oracle Database Permissions Required If Not Using SYSTEM for the System User

If you are running the installer with a different user created for the purpose of system admin, that is not SYSTEM, or if your SYSTEM permissions are different, you may need to run these grants:

replace “USER” with your database user name.

replace “DATA_PUMP_DIR“ with your database export directory name

--to allow creating schemas and anything in schemas

grant CREATE USER, CREATE ANY JOB, CREATE ANY MATERIALIZED VIEW, CREATE ANY PROCEDURE, CREATE ANY SEQUENCE, CREATE SESSION, CREATE ANY SYNONYM, CREATE ANY TABLE, CREATE ANY TRIGGER, CREATE ANY TYPE, CREATE ANY VIEW to USER;

--to allow backup and restore

grant exp_full_database, imp_full_database to USER;
grant read, write on directory DATA_PUMP_DIR to USER;