- Oracle SQL Developer
- Table of Contents
- Oracle SQL Developer
- Credits
- About the Author
- About the Reviewer
- www.PacktPub.com
- Preface
- 1. Getting Started with SQL Developer 4.1
- Preparing your environment
- A quick overview
- Navigating around SQL Developer
- Database certification matrix (Oracle & Third-Party)
- Finding more help
- Summary
- 2. Database Connections and SQL Worksheet
- Working with the Connections navigator
- Working with database objects
- Display editors
- Working with the data grids
- Reviewing other database object nodes
- Creating new database objects
- Editing database objects – putting context menus to work
- Script Runner/Running scripts
- Command-line interface for SQL formatting
- SQL Worksheet "hints" for formatting output
- Summary
- 3. The Power of SQL Reports
- Introducing SQL Developer reports
- Creating your own reports
- DB Doc generation
- Summary
- 4. Working with PL/SQL
- 5. SQL Developer for DBAs
- Database instance viewer
- Finding database objects
- Database configuration – initialization parameters
- Automatic undo management
- Current database properties
- Restore points
- Data Pump
- Export Jobs
- Import Jobs
- Performance
- Snapshots (filtered)
- Baselines
- Baseline templates
- Automatic Database Diagnostic Monitor (ADDM)
- ASH Report Viewer
- AWR
- RMAN Backup/Recovery
- Resource manager
- Consumer group mappings
- Consumer groups
- Plans
- Settings
- Statistics
- Scheduler
- Global Attributes
- Job Classes
- External Destinations
- Security
- Audit Settings
- Profiles
- Roles
- Users
- Storage
- Archive Logs
- Control Files
- Datafiles
- Redo Log Groups
- Rollback Segments
- Tablespaces
- Temporary Tablespace Groups
- Summary
- 6. SQL Developer Accessibility
- Screen reader readability
- Keyboard access
- Font and color choices
- No audio-only feedback
- Screen magnifier usability
- Change the editor or tabbed view of a file
- Read text in a multi-line edit field
- Read the line number in the source editor
- Customize the accelerators keys
- The look and feel of SQL Developer
- Customize syntax highlighting
- Display line numbers in Code Editor
- Timing for completion insight
- Specify the columns in the Debugger
- Summary
- 7. Importing, Exporting, and Working with Data
- 8. Database Connections and JDBC Drivers
- 9. Introducing SQL Developer Data Modeler
- Oracle SQL Developer Data Modeler
- Getting started
- Working with diagrams and their components
- Analysis, design, and generation
- Summary
- 10. Extending SQL Developer
- Introducing extensibility
- Working with extensions
- Summary
- 11. Working with Application Express
- 12. Working with SQL Developer Migrations
- 13. Oracle Data Miner 4.1
- 14. REST Data Services and REST Development
- Index
Data Pump is an important logical backup and restore mechanism used by DBAs. The Data Pump feature helps us to export database, table spaces, schemas, and tables logically from one database and import it to another database. The DBA navigation pane gives us the export and import data pump wizards to carry out Data Pump jobs, as shown in the next screenshot.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.