Oracle Schema Export and Import Utility

There is an opportunity in dbForge Studio for Oracle to export a full schema structure or only selected schema objects using its schema export and import utility. With Devart dbForge Studio for Oracle, you can easily backup and recover Oracle objects using Schema Export and Import wizards. dbForge Studio exports a database object into a simple SQL script that can be read and modified before importing.

Using Schema Export/Import Wizard

Schema export and import wizards are intended to help DBAs to backup and recover Oracle databases.

You can select any of five levels to compress your files, use auto delete of old Oracle backup files to free your disc space, choose information to export, and set extended options for a database to export, backup structure, users, or a script. Unlike binary Oracle backup process, database is dumped in SQL format.

There is also a possibility to save your settings along with connections as a project for the next time or for using them in the command line interface.

Schema Export/Import Wizard

Using Oracle Export/Import Utility

dbForge Studio for Oracle provides convenient Export/Import Utility wizards for working with the command line interface of Oracle export and import utilities. This feature will save your time as you do not need to work with the command line interface of Oracle export and import utilities directly.

Export Utility - Export Modes

dbForge Studio for Oracle

Multifunctional Oracle GUI

Availability in the editions of dbForge Studio for Oracle

Feature

Enterprise
Professional
Standard
Express
Schema Export and Import
Yes
Yes
Yes
Export and Import Utility Wizards
Yes
Yes
Yes
None

* Express Edition does not support command line, schema export projects, auto deletion of old export files, compression, schema export files larger than 1MB.