Oracle error

Roopanwita · Post by **Roopanwita** » Mon May 19, 2008 7:11 am

In one job while loading from Sequential file to Oracle table (in Oracle table Load Option is Create ) job is throwing error ORA-00972: identifier is too long . I shaeched from google ,but couldn't get meaning of identifier is too long

Can anyone please help me out?

Thanks,
Roopanwita

Roopanwita · Post by **Roopanwita** » Mon May 19, 2008 7:13 am

Is the above problem is because of too long target table name / job name?

chulett · Post by **chulett** » Mon May 19, 2008 7:17 am

Most likely. A table name cannot be longer than 30 characters, for example.

Roopanwita · Post by **Roopanwita** » Mon May 19, 2008 7:42 am

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon May 19, 2008 5:21 pm

That is an Oracle restriction, not a DataStage restriction. Other database servers have similar (but different) restrictions.