Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle Database XE 11gR2 Jump Start Guide
  • Table Of Contents Toc
  • Feedback & Rating feedback
Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

By : Asif Momen
4.3 (3)
close
close
Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

4.3 (3)
By: Asif Momen

Overview of this book

Oracle Database XE 11gR2 is an excellent beginner-level database and is a great platform to learn database concepts. "Oracle Database XE 11gR2 Jump Start Guide" helps you to install, administer, maintain, tune, back up and upgrade your Oracle Database Express Edition. The book also helps you to build custom database applications using Oracle Application Express.Using this book, you will be able to install Oracle Database XE on Windows/Linux operating system.This book helps you understand different database editions and it guides you through the installation procedure with the aid of screenshots. You will learn to interact with the database objects. You will gain a solid understanding of stored sub-programs which is followed by an introduction to Oracle Application Express (APEX). Solid database performance tuning strategies are also discussed in this book followed by backup and recovery scenarios. All in all, "Oracle Database XE 11gR2 Jump Start Guide" delivers everything that you should know to get started with Oracle Database administration.
Table of Contents (20 chapters)
close
close
Oracle Database XE 11gR2 Jump Start Guide
In Progress | 0 / 1 sections completed | 0%
Credits
In Progress | 0 / 1 sections completed | 0%
About the Author
In Progress | 0 / 1 sections completed | 0%
Acknowledgement
In Progress | 0 / 1 sections completed | 0%
About the Reviewers
In Progress | 0 / 1 sections completed | 0%
www.PacktPub.com
In Progress | 0 / 1 sections completed | 0%
Preface
In Progress | 0 / 1 sections completed | 0%
Lock Free Chapter
1
Database Editions and Oracle Database XE
In Progress | 0 / 5 sections completed | 0%
3
Connecting and Configuring Oracle Database 11g XE
In Progress | 0 / 5 sections completed | 0%
10
Upgrading Oracle Database 11g XE to Other Database Editions
In Progress | 0 / 3 sections completed | 0%
1
Features Available with Oracle Database 11g XE
In Progress | 0 / 3 sections completed | 0%

Physical and logical database structures


A database is a collection of physical operating system files. The files that make up a database are redo logfiles, datafiles, control files, and temporary files. A logical database structure consists of tablespaces.

A tablespace is a logical storage unit within Oracle Database 11g XE. It is considered logical because a tablespace is not visible in the filesystem. A tablespace is a collection of one or more datafiles. A datafile belongs to one and only one tablespace. There are three types of tablespace in Oracle Database 11g XE — permanent, temporary, and undo. All our tables, indexes, and stored subprograms reside in a permanent tablespace. A temporary tablespace is used to process temporary data such as storing intermediate sorting results. All information related to undo (roll back) is stored in the undo tablespace. Undo records are used to roll back transactions when a ROLLBACK statement is issued or during recovery of the database.

Datafiles...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon