Loading into Target (Oracle) using RCP
Posted: Tue Aug 10, 2010 1:04 pm
Hi,
I am creating a job to take snapshots of few tables. So my job design is to read data from source (Oracle) and write all the records into Target (Oracle). This is supposed to be a generic job which will take Source and Target table names as parameters and load the data. This job is running fine for smaller tables but is failing for a table with 186 columns. Looks like the SQLLDR control file is not getting generated properly (size limitation) by DS. I read in another posting that some one faced similar issue and they got a patch from IBM to resolve it.
Are there any workarounds other than applying a patch?
I tried creating a job with metadata (not using RCP) and using Upsert and this is working fine. While doing this, I noticed that runtime of the job is similar between both the designs. However when I use Upsert with RCP, Oracle Enterprise stage is expecting some metadata <<MISSING FIELD>> in the Insert and Update SQLs. So I want to know whether we can use RCP and Upsert together so that the job can still be generic and I can avoid using SQLLDR.
Thanks for your time.
Thanks & Regards,
Suresh
I am creating a job to take snapshots of few tables. So my job design is to read data from source (Oracle) and write all the records into Target (Oracle). This is supposed to be a generic job which will take Source and Target table names as parameters and load the data. This job is running fine for smaller tables but is failing for a table with 186 columns. Looks like the SQLLDR control file is not getting generated properly (size limitation) by DS. I read in another posting that some one faced similar issue and they got a patch from IBM to resolve it.
Are there any workarounds other than applying a patch?
I tried creating a job with metadata (not using RCP) and using Upsert and this is working fine. While doing this, I noticed that runtime of the job is similar between both the designs. However when I use Upsert with RCP, Oracle Enterprise stage is expecting some metadata <<MISSING FIELD>> in the Insert and Update SQLs. So I want to know whether we can use RCP and Upsert together so that the job can still be generic and I can avoid using SQLLDR.
Thanks for your time.
Thanks & Regards,
Suresh