- 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
Oracle Flashback database and restore points enable us to rewind the database back in time to correct any problems caused by logical data corruption or user errors, and it doesn't require any restoration of backup. There are two types of restoration points, which are as follows:
- Normal Restore Point: Assigns a restore point name to an SCN or specific point in time. The control file stores the name of the restore point and the SCN.
- Guaranteed Restore Point: Is a normal restore point, but additionally serves as an alias for an SCN in recovery operation. The only difference is that the guaranteed restore points never age out of the control file and must be explicitly dropped.
To create a restore point or view existing restore points, click on Restore Points.
- View Database Feature Usage: Selecting this option shows us the list of all available database features and the detected count of usages and versions of all those features.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.