Loading issue in Partition table

vinodhraj · Post by **vinodhraj** » Thu Sep 16, 2010 9:52 pm

Hi,

I am facing performance issue in loading data from sequentail file to partitioned table (Oracle EE stage) . The same file while loading through SQLLDR finishes in 1 min but takes 45 min when loading through datastage.
No of records in file: 350

There is no indexes in the target table and constraints were disabled in Oracle EE stage.

Please help me in this regard.

Thanks
Vinod

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Sep 17, 2010 2:38 am

Run in a single node config and check the ctl file.

vinodhraj · Post by **vinodhraj** » Fri Sep 17, 2010 5:13 am

Changed the node as 1 and executed. Again same problem.

chulett · Post by **chulett** » Fri Sep 17, 2010 5:39 am

Details, please, especially the options you are using in your target stage so we have some idea exactly what kind of 'load' it is doing.

vinodhraj · Post by **vinodhraj** » Sat Sep 18, 2010 3:51 am

Thanks team. I have reset the ORACLE LOAD OPTIONS, with DIRECT=FALSE, then it worked out.