|
DBF Loader utility designed for
interactive
loading DBF-formatted file to Oracle database. Data files with other formats
must be converted to DBF-format before loading. It can be easy done with MS
Excel. You can find instruction for file converting below.
Oracle
supplied SQL*Loader utility always require control file for processing. The
writing of control file requires knowledge file format and time resource.
DBF Loader utility don't require any configuration file for processing
because it read header of DBF-file to get all information about fields
format. Loading performance of DBF Loader is the same as SQL*Loader utility.
Features
- Table
for loading are creating during loading process. Loading to existing
table not supported due safety reason.
- All
dbf-file data types will be converted to varchar2. You can later convert
it to other type using standard Oracle functions to_number and to_date.
- File
source must not be used any program (must be closed).
- DBF
Loader utility require Oracle Client installed.
|
