|
Re: Wat is the best UTL_FILE or sql Loader ? [message #39177 is a reply to message #39175] |
Mon, 24 June 2002 12:26 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
sqlloader has good options like direct mode for high speed loading. It's also easy to get support on.
ULT_FILE is great for inttegrating read/write from pl/sql but probably couldn't compete with sqlloader on speed. UTL_FILE in pl/sql allows you easy acces to the data read to manipulate it in any way before you intert it into a table.
sqlloader can load multiple rows at a time. When one of the records violates a PK or size constraint or whatever, sqlloader tries to load the records in that set individually. This would be lots of coding in pl/sql.
|
|
|
|
Re: Wat is the best UTL_FILE or sql Loader ? [message #39241 is a reply to message #39175] |
Fri, 28 June 2002 21:13 |
santosh
Messages: 85 Registered: October 2000
|
Member |
|
|
UTL_FILE is a DBMS package provided for FILE READ WRITE operations .Although it is not complete with all functionality.And provides only basic methods for read write.
SQLLDR is utility provided for database replication and backups . One can load data from plain format to oracle database using sqlldr.It is traditional way of loading data into structures.
It has got various advantages like automatic creation of log file which gives detailed report during loading data.It contains automatic creation for bad file containing bad records .So u dont need to worry about loosing unloaded records. and it is comparitavely faster as it is the basic utility provided by oracle.
|
|
|