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.

    Note

    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. Open Command Prompt.

Note

To run the Command Line in Windows 10:

From the Desktop Mode

  • Move the mouse cursor to the exact lower left corner until the desktop shortcuts menu appears.
  • Right-click to see the shortcut menu and than click Run.

From the Charms Bar

  • Move your mouse to the upper right corner until the Charms Bar appears.
  • Select Apps from the list and type ‘run’ in the search box.
  • Click Run from the search results.

Use Windows + R Shortcut Keys

  • In desktop mode, press the Windows + R keys, to show the Run command line.
  • In the window that opens, type cmd and press Enter.
  1. Type a path to the dbforgeoracle.com 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\dbforgeoracle.com"

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?
Download a free 30-day trial