Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help ! Performance question : utl_file or sql*loader?
Greg,
Thanks for clarifying that the utl_file reads might be as good as sql*loader reads if not better. I was thinking that sql*loader direct load (not the conventional load), a select on temporary table and a bunch of pl/sql inserts might outperform utl_file reads and pl/sql parses and pl/sql inserts. If there is not a significant penalty in utl_file reads then I guess I will stick with the utl_file approach.
Thanks a bunch
Prahalad
(ppateel_at_iname.com)
Received on Wed Jul 26 2000 - 00:00:00 CDT