Hi,
I want to know the better way of loading a Oracle table(10g).
While loading millions of records into Oracle table, which option should be chosen for better performance (without any deadlock issue)?
- Using Upsert
- Splitting the data stream into 'Insert' & 'Update' stream and using
two Oracle Enterpise stage as target
Thanks in advance !
Ankita
Loading to Oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 83
- Joined: Tue Dec 19, 2006 8:38 am
Re: Loading to Oracle
Hi Ankita,ankita wrote:Hi,
I want to know the better way of loading a Oracle table(10g).
While loading millions of records into Oracle table, which option should be chosen for better performance (without any deadlock issue)?
- Using Upsert
- Splitting the data stream into 'Insert' & 'Update' stream and using
two Oracle Enterpise stage as target
Thanks in advance !
Ankita
I believe its the second option
Using different streams for insert and update.
Thanks
George
-
- Participant
- Posts: 17
- Joined: Fri Jul 30, 2004 1:16 am