Name: Oracle Database XE 11gR2 Jump Start Guide
Author: Asif Momen
ISBN: 9781849686754

微信读书书城Oracle Database XE 11gR2 Jump Start Guide

首页我的书架登录

翻译完成

切换

Oracle Database XE 11gR2 Jump Start Guide

Asif Momen

扉页
coverpage
+书签
Oracle Database XE 11gR2 Jump Start Guide
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Database Editions and Oracle Database XE
About Oracle
Oracle Database Express Edition (XE)
Summary
References
Chapter 2. Installing and Uninstalling Oracle Database XE
Downloading Oracle Database 11g XE
Installing Oracle Database 11g XE on Windows XP (32-bit)
Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
Summary
Chapter 3. Connecting and Configuring Oracle Database 11g XE
Local database connections
Remote database connections
Changing SGA and PGA sizes
Summary
Chapter 4. Accessing Table Data, DML Statements, and Transactions
Unlocking sample user accounts
Installing SQL Developer
Connecting SQL Developer to Oracle Database 11g XE
About TAB and DUAL
Writing simple queries
Selecting data from multiple tables
Exploring common functions
What are Transaction Control Statements?
Understanding DML statements
Summary
References
Chapter 5. Creating and Managing Schema Objects
Data Definition Language
Creating and managing tables
Creating and managing indexes
Integrity constraints
Creating and managing views
Creating and managing synonyms
Creating and managing sequences
Gathering statistics
Summary
References
Chapter 6. Developing Stored Subprograms and Triggers
PL/SQL data types
Stored subprograms
Creating stored subprograms
About packages
Exception handling
Wrapping up the PL/SQL stored programs
PL/SQL triggers
Summary
References
Chapter 7. Building a Sample Application with Oracle Application Express
What is Oracle Application Express (APEX)?
Creating application users
Loading and unloading data to a text file
Application Express Dashboard
Summary
References
Chapter 8. Managing Database and Database Storage
Memory structure
Automatic Memory Management
Important background processes
Physical and logical database structures
Managing the Flash Recovery Area
Summary
Chapter 9. Moving Data between Oracle Databases
Exporting and importing data
Moving data between Oracle Database 10g XE and Oracle Database 11g XE
Exporting data using SQL Developer
Summary
Chapter 10. Upgrading Oracle Database 11g XE to Other Database Editions
Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition
Summary
Chapter 11. Backup and Recovery
Introduction to backup and recovery
Recovery Manager
Connecting to Oracle Database XE using RMAN
The ARCHIVELOG mode
Backing up a database (the NOARCHIVELOG mode)
Simulating a database failure (the NOARCHIVELOG mode)
Restoring the NOARCHIVELOG database
Configuring the RMAN environment
Backing up the ARCHIVELOG database
Simulating a database failure (the ARCHIVELOG mode)
Restoring the ARCHIVELOG database
Summary
References
Chapter 12. Tuning Oracle Database 11g XE
Performance tuning
Performance tuning approach
Avoiding common pitfalls
Autotrace utility
Explain Plan
Using indexes
Dynamic performance views
Statspack
Summary
References
Appendix A. Features Available with Oracle Database 11g XE
Features available
Features not available
Index

简介

版权

Oracle Database XE 11gR2 Jump Start Guide