ORACLE OCI BULK LOAD truncate option.

karry450 · Post by **karry450** » Thu May 27, 2010 2:24 am

Hi Friends,

I am loading the target (oracle) from a flat file using ORACLE OCI BULK but before loading I want truncate the target table. But there is no option to delete or truncate the table before loading in ORACLE OCI BULK stage. Can anyone help me with alternate way without creating one more job for truncating the table.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu May 27, 2010 3:39 am

replace

chulett · Post by **chulett** » Thu May 27, 2010 6:52 am

Replace is not the same as truncate. Google for 'oracle sqlldr truncate'. I don't believe the truncate option is supported through the GUI, you may need to do it as a separate step.

srinivas.g · Post by **srinivas.g** » Thu May 27, 2010 7:24 am

In Before job sub routine calls the shell script. in side the shell script call delete statement.