Release 3.1 continues to expand on SQL Developer's DBA functionality. RMAN, Oracle Recovery Manager, is now part of the DBA navigator. An easy to use wizard takes you through the scheduling of a full database backup. Backups can be stored to disk, tape or a combination. RMAN scripts are generated to restore or recover a whole database, tablespaces, datafiles and archived logs. Reports are available to manage backup jobs, backup sets, image copies and RMAN settings.
To enable very high speed movement of data and metadata from one database to another, SQL Developer has added the Oracle Data Pump technology. Use SQL Developer's Data Pump UI to import and export your Database, Tablespaces, Schemas, and Tables. Select the option to import and export just the DDL, Data or both. Data Pump also offers scheduling capabilities. Learn more by viewing these demonstrations.
Completely redesigned, DB Diff now provides a more reliable comparison and difference management support of your DDL. Select what to include in your DDL Generation and select from various comparison options such as match constraints by name or by definition. Objects can be further filtered. Scripts are generated to synchronize the source and target destinations.
The Reports dialog is enhanced for ease of use and flexibility to create or update a report. The PDF feature allows the user to change and save their PDF options for a specific report in the Reports Navigator. Customize the visual layout and apply security with password protected encryption to your PDF Reports. Learn more by viewing these demonstrations.