Datastage Tuncation Error

natashab · Post by **natashab** » Mon Sep 20, 2010 12:40 am

A job is designed with a source oracle stage loading to a target oracle stage through a transformer stage.When the job is executed it aborts with the below error.

Target: Table truncation failed for "SCHEMA.TABLENAME".

Is it a database issue, i.e - Privilege to truncate the table is not given or is it something else that's stopping the job from executing successfully

ray.wurlod · Post by **ray.wurlod** » Mon Sep 20, 2010 1:08 am

TRUNCATE is a specific and separate privilege in Oracle.

natashab · Post by **natashab** » Mon Sep 20, 2010 1:30 am

what should be done to make the job run without the truncation failed error?

arunpramanik · Post by **arunpramanik** » Mon Sep 20, 2010 1:39 am

natashab wrote:what should be done to make the job run without the truncation failed error?

Check the user rights/privilege of the Oracle user which you are using has the proper right to truncate.

chulett · Post by **chulett** » Mon Sep 20, 2010 6:00 am

I would think more messages than that would be involved here. The table could be "busy", in use by another process and thus not truncatable.