While loading large amount of data using ODBC it is slow,
is there any other alternative way to load data very fastly if there is any long Varchar field, because if we increase the transactuion size for the table having long varchar we are getting error while loading. the error is:
Abnormal termination..................is there any solution for this.......to load data in effective way
Reg Loading using ODBC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Tue May 13, 2008 9:55 pm
- Location: Chennai
- Contact:
Reg Loading using ODBC
Pradeep KUmar, Chennai.
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
Re: Reg Loading using ODBC
If you are using oracle then use a primary key index and if possible add a parallel hint to your query. So that you no need to change your DS code.