Skip to Content
0
Former Member
Jan 12, 2011 at 02:52 PM

Backgroung job failing

29 Views

Hi,

We have NW IDM 7.1 on a HP Unix - Oracle 10.2 . I have installed the identity centre on my dektop and have successully connected to the databse.

I cretaed a dispatcher and then tried to craete a simple job with a from ASCII file. This was to read data from a CSV file. But he job runs into an error with following message.

Creating table Data from HRData failed. SQL:CREATE TABLE Data from HRData(Employee_Id VARCHAR2(255),Last_Name VARCHAR2(255),First_name VARCHAR2(255),Title VARCHAR2(255),Department VARCHAR2(255),Location VARCHAR2(255),Job_Role VARCHAR2(255))

java.sql.SQLException: ORA-00922: missing or invalid option

What could be the possible error ?

Regards,

Shailesh