Importing Data through Command Line

You can automate data import process using command line. Such possibility can be very useful if you need to import data to the same table or view quite often. In this case you can create a template file using Data Import Wizard, where all import settings will be saved, and perform import by specifying the name of this file in the command line instead of going through all wizard pages. Note that some parameters like connection, input file, and some others can be specified directly in the command line. In this case values of these parameters specified in your template file will be overridden.

To create a template file, do the following:

  1. On the Database menu, click Export Data to open the Data Import Wizard.
  2. Go through all wizard pages and specify necessary information and settings.
  3. When all necessary settings were made, click Save on any of the wizard’s pages.

    The generated file does not contain password information for security purposes. If the Save Password option is selected for the connection in dbForge Studio for Oracle, you should not do anything regarding the password. If it is not, then you should define the password with the help of the /password option.


    It is not necessary to click Import in the wizard and perform the import process itself to create a template file.

To import data through command line, do the following:

  1. To open Command Prompt, press Win+R and type cmd in the Open line.
  2. Type a path to the file, located in dbForge Studio for Oracle installation folder on your PC, and press the SPACE key:
C:\Users\user>"C:\Program Files\Devart\dbForge Studio for Oracle\"