Page 1 of 1

FAQ

PostPosted: Tue Jul 13, 2010 5:49 pm
by admin
1. How more optimum to load considerable quantity DBF of files into one table ORACLE?
What is the optimal way to load a lot of DBF files into one ORACLE table?

Re: FAQ

PostPosted: Tue Jul 13, 2010 5:50 pm
by admin
You can use SQL * Loader to import data, with the following import settings:
Exclude preprocessing check (before SQL * Loader) - Checked
Use Direct Path Loads: - Checked
Use unrecoverable: - Checked
Modes import data: - APPEND

FAQ

PostPosted: Tue Jul 13, 2010 5:56 pm
by admin
2. Why DBF file is not loading?

Re: FAQ

PostPosted: Tue Jul 13, 2010 5:57 pm
by admin
Check the file structure with the program “Check and repair DBF files”.
The Demo of that program, checks and shows errors in DBF file headers.
Perhaps this is the problem.

FAQ

PostPosted: Tue Jul 13, 2010 5:58 pm
by admin
3. Will you add the possibility to change field names and formats (at a loading stage) in the next versions?

Re: FAQ

PostPosted: Tue Jul 13, 2010 5:59 pm
by admin
No, the main objective of this program is to quickly import data from DBF files. The change of field names and formats is much easier done in the Oracle database.