Packt+ | Advance your knowledge in tech

You're reading from Oracle Database XE 11gR2 Jump Start Guide Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.

Product type Paperback

Published in Jul 2012

Publisher Packt

ISBN-13 9781849686747

Length 146 pages

Edition 1st Edition

Languages

Java

Tools

Oracle Database

Concepts

Database Programming

Author (1):

Asif Momen

View More author details

Table of Contents (20) Chapters

Oracle Database XE 11gR2 Jump Start Guide

Credits

About the Author

Acknowledgement

About the Reviewers

1. www.PacktPub.com

2. Preface

1. Database Editions and Oracle Database XE FREE CHAPTER

2. Installing and Uninstalling Oracle Database XE

3. Connecting and Configuring Oracle Database 11g XE

4. Accessing Table Data, DML Statements, and Transactions

5. Creating and Managing Schema Objects

6. Developing Stored Subprograms and Triggers

7. Building a Sample Application with Oracle Application Express

8. Managing Database and Database Storage

9. Moving Data between Oracle Databases

10. Upgrading Oracle Database 11g XE to Other Database Editions

11. Backup and Recovery

12. Tuning Oracle Database 11g XE

Features Available with Oracle Database 11g XE

Chapter 10. Upgrading Oracle Database 11g XE to Other Database Editions

Indeed, an ignorant man who is generous is dearer to God than a worshipper who is miserly. - Prophet Muhammed

In this chapter we will learn how to upgrade Oracle Database 11g XE to other database editions. Oracle Database 11g XE offers upgrade as you go. Oracle grows with your needs, offering a smooth upgrade path.

Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition

This section provides a step-by-step guide on upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition. Ensure that the release number and patch level of Enterprise Edition server software are the same as the original Express Edition server software. For example, if the Express Edition is 11.2.0.2, then your Enterprise Edition should also be 11.2.0.2.

The following are the steps to upgrade Oracle Database 11g XE (11.2.0.2) to Oracle Database 11g Enterprise Edition on a Windows environment: