1 Introducing Oracle Database XE

Oracle Database Express Edition (Oracle Database XE) is a free, smaller-footprint edition of Oracle Database. Oracle Database XE is easy to install and easy to manage.

With Oracle Database XE and related tools you can:

  • Administer the database

  • Create tables, views, and other database objects

  • Import, export, and view table data

  • Run queries and SQL scripts

This guide assumes that you are familiar with the following concepts and operations described in Oracle Database Express Edition Getting Started Guide:

  • The Oracle Database XE user interface, including the system menu commands and the database administration interface

  • Creating a database user

  • Installing and using SQL Developer, including creating database connections

If you are not familiar with these basics, see the Oracle Database Express Edition Getting Started Guide for a quick overview. (However, you do not need to do the tutorial for creating an Oracle Application Express application in that guide, because that is nor directly relevant to DBA activities.)

The remaining chapters cover the following topics: