Hello
I have a requirement like i have a huge file with 10 million records and i need to load the data to oracle table. We are using Parallel Edition on unix AIX box. Which option would be the best.I also have a requirement where if the job aborts in the middle of loading i need to rollback on what ever records got inserted/updated.
Appreciate your help
Thanks
Regarding best option to load to oracle database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Well... your rollback requirement means no direct path bulk loads. So you'll need to stick with conventional loads but we'd need more information to give better advice - always inserts? A mixture of inserts / updates? If a mixture, any idea about the ratio?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers