There are a few tweaks required to get the Bulk Load Utility functioning as it does not work straight out of the box.
First, you will need to create a table space in the database. The code below should do, but feel free to adjust as needed:
create tablespace tspace logging datafile '/opt/oracle/tspace.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;Second, the utility runs under the OIM user account and, by default, does not have sufficient privileges causing the tool to error out. To fix this, try the following:
grant CREATE ANY SYNONYM, CREATE ANY TRIGGER, CREATE ANY TYPE, CREATE DATABASE LINK, CREATE JOB, CREATE LIBRARY, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE , CREATE TRIGGER , CREATE VIEW to oimuser;More Here
Courtesy:http://www.idmworks.com/blog/oim-bulk-load-utility-db-permissions