Previous Next

Data Import and Export Tools for Oracle

When working with Oracle databases, you may need to migrate Oracle data for copying to a new database after an upgrade or creating a backup. With the help of Oracle export tool that is supplied with dbForge Studio for Oracle you can easily export Oracle table data to different file formats. Once the table data was exported, you can import it any time using Oracle import tool.

Key Features

  • Data export to CSV, DBF, HTML, XLS, XLSX, RTF, XML, ODBC, Text,
    MDB (Access), PDF, SQL formats
  • Data import from: CSV, DBF, XML, ODBC, Text, XLS, XLSX,
    MDB (Access) formats
  • Migration of Oracle data from the command-line interface
  • Export only of selected rows
  • Saving export options

Export of data

With our Oracle migration utility, you can easily export data from one or several tables to the following file formats:

  • HTML (Hyper Text Markup Language) - a data storage format used for the web pages
  • Text - plain text format
  • MS Excel - Microsoft Excel spreadsheet (XLS)
  • MS Excel 2007 - Microsoft Excel 2007 spreadsheet (XLSX)
  • MS Access - database of well-known Microsoft DBMS Access (MDB)
  • RTF - Rich Text Format from Microsoft
  • PDF (Portable Document Format) - file format, created by Adobe Systems for document exchange. (Only Latin charset data can be exported.)
  • XML (XML Schema Definition) - XML data representation with data contained in attributes. Contains XML schema.
  • CSV (Comma-separated values) - another name for the comma-delimited format of data storage
  • ODBC (Open Database Connectivity) - a data storage format used to access to any data source, for example, to data in MySQL, SQL Server, PostgreSQL]
  • DBF - a dBASE data storage format used in Paradox or FoxPro DBMS. (While exporting data, ANSI charset is used.)
  • SQL - data is exported to SQL statements. (Data can be exported to INSERT, UPDATE, DELETE, and MERGE statements.)

dbForge Studio for Oracle gives a simple way to migrate Oracle table data from Database Explorer.

Also you can compose a complex query, execute it, and then select the data to export from the grid.

dbForge Studio for Oracle includes Data Export Wizard which allows you to select the following:

  • columns
  • data formats for each field
  • additional options for each exported format

Basing on your needs, you can save your selected export options into a template file for the further usage in the wizard or for exporting data through the command line.

Import of data

With Oracle data migration utility, you can easily import data to Oracle table from the following file formats:

  • Text - plain text format.
  • MS Excel - Microsoft Excel spreadsheet (XLS).
  • MS Excel 2007 - modern and universal format of Microsoft Excel spreadsheet (XLSX).
  • MS Access - database of well-known Microsoft DBMS Access (MDB).
  • XML (XML Schema Definition) - XML data representation with data contained in attributes. Contains XML schema.
  • CSV (Comma-separated values) - another name for the comma-delimited format of data storage.
  • ODBC (Open Database Connectivity) - a data storage format used to access to any data source, for example, to data in MySQL, SQL Server, PostgreSQL.
  • DBF - a dBASE data storage format used in Paradox or FoxPro DBMS. (While exporting data, ANSI charset is used. Import from Visual FoxPro Memo Field is not supported.)

Availability in editions of dbForge Studio for Oracle

Features

Pro

Stand

Exp

Data import and data export
Yes
Yes
Click to view restrictions
Data import/export through the command line
Yes
No
No

* CSV format has no restrictions for data export and import, for other formats only first 50 rows are processed. User templates are not supported.