OCI Bulk Loader data & control file

Veni · Post by **Veni** » Fri Jan 13, 2006 12:23 pm

Hi

Is any one help me in knowing where the OCI Bulk loader store the control and data file when we are using automatic option.

I wants to know the path of control and data file.

Thanks in advance

chulett · Post by **chulett** » Fri Jan 13, 2006 12:24 pm

From what I recall - wherever you tell it to put it. It's a property in the stage.

rleishman · Post by **rleishman** » Mon Jan 16, 2006 12:09 am

If you are using the stage called "Oracle OCI Load", it doesn't use SQL*Loader in Automatic Mode, so there is no Control file. OCI (Oracle Call Interface) provides a programatic direct-path interface that allows DS to link the load code directly into the plugin.

I have another stage called "Oracle 7 Load" - I don't know how this one works, but I don't use it.

balajisr · Post by **balajisr** » Mon Jan 16, 2006 12:21 am

Hi

When in automatic mode control file is not created. Automatic mode establishes connection with the database and populates the data from the source to the database.

It creates control file only in the manual mode where the data is not populated to the database and control file is created.

--Balaji S.R