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
Loading issue in Partition table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom