FAQ

Get support for the "DBF Data Import for ORACLE" tool

FAQ

Postby admin » Tue Jul 13, 2010 5:49 pm

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?
admin
Site Admin
 
Posts: 8
Joined: Thu May 06, 2010 7:23 am

Re: FAQ

Postby admin » Tue Jul 13, 2010 5:50 pm

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
admin
Site Admin
 
Posts: 8
Joined: Thu May 06, 2010 7:23 am

FAQ

Postby admin » Tue Jul 13, 2010 5:56 pm

2. Why DBF file is not loading?
admin
Site Admin
 
Posts: 8
Joined: Thu May 06, 2010 7:23 am

Re: FAQ

Postby admin » Tue Jul 13, 2010 5:57 pm

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.
admin
Site Admin
 
Posts: 8
Joined: Thu May 06, 2010 7:23 am

FAQ

Postby admin » Tue Jul 13, 2010 5:58 pm

3. Will you add the possibility to change field names and formats (at a loading stage) in the next versions?
admin
Site Admin
 
Posts: 8
Joined: Thu May 06, 2010 7:23 am

Re: FAQ

Postby admin » Tue Jul 13, 2010 5:59 pm

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.
admin
Site Admin
 
Posts: 8
Joined: Thu May 06, 2010 7:23 am


Return to DBF Data Import for ORACLE



cron