Data Import and Export with dbForge Studio for Oracle
When working with Oracle databases, you may need to import and export 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 Devart 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.
Features
-
Data export to CSV, DBF, HTML, XLS, RTF, XML, ODBC, Text, MDB (Access), PDF, SQL
formats
-
Export only of selected rows
-
Saving export options
-
Export and import of data from command line interface
-
Data import from: CSV, DBF, XML, ODBC, Text, XLS, XLSX, MDB (Access) formats
See also
Export of data
With our Oracle export tool you can easily export data from one or several
tables to the following file formats:
Data Export - Select File Format
Data Export - Select File Format
-
HTML (Hyper Text Markup Language) - a data storage format used for the web pages.
-
MS Excel - Microsoft Excel spreadsheet.
-
RTF - Rich Text Format from Microsoft.
-
XML (XML Schema Definition) - XML data representation with data contained in attributes.
Contains XML schema.
-
ODBC (Open Database Connectivity) - a data storage format used to access any data
from any application.
-
Text - plain text format.
-
MS Access - database of well-known Microsoft DBMS Access.
-
PDF (Portable Document Format) - file format, created by Adobe Systems for document
exchange. (Only Latin charset data can be exported.)
-
CSV (Comma-separated values) - another name for the comma-delimited format of data
storage.
-
DBF - a data storage format used in 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 export Oracle table data
from Database Explorer.
Data Export - Export From Database Explorer
Also you can compose a complex query, execute it, and then select the data to export
from the grid.
Data Export - Export From 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.
Data Export - Save Export Options
Availability in editions of dbForge Studio for Oracle
* Express Edition fully supports export to CSV format and export only
of 50 rows in other formats.
Import of data
With Data Import Wizard you can easily
import data to Oracle table from the
following file
formats:
Data Import - Select File Format
-
Text - plain text format.
-
MS Excel - Microsoft Excel spreadsheet.
-
MS Excel 2007 - Microsoft Excel spreadsheet.
-
MS Access - database of well-known Microsoft DBMS Access.
-
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 any data
from any application.
-
DBF - a data storage format used in FoxPro DBMS. (While exporting data, ANSI charset
is used.)
Availability
* Express Edition fully supports import from CSV format and import only
of 50 rows in other formats.