Previous Next

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 copy database objects easily 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 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.

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.

Availability in editions of dbForge Studio for Oracle





Schema Export and Import
Click to view restrictions
Export and Import Utility Wizards

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