Skip Headers
Oracle® Database Express Edition 2 Day DBA
10g Release 2 (10.2)

Part Number B25107-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


Welcome to Oracle Database Express Edition 2 Day DBA. This documentation provides background and how-to information for administering Oracle Database Express Edition. The preface contains the following sections:

Documentation Topics

Title Description
Introducing Oracle Database XE
Introduces Oracle Database Express Edition (Oracle Database XE). Explains how to access the Database Home Page and how to use the Oracle Database XE graphical user interface.
Starting Up and Shutting Down
Describes how to start up and shut down the database both from the desktop and from SQL Command Line (SQL*Plus).
Connecting to the Database
Explains how to connect to the database locally and remotely with SQL Command Line (SQL*Plus) and other Oracle utilities.
Managing Network Connections
Explains how to enable and disable remote connection requests, and how to configure the TCP port numbers that listen for these requests.
Managing Database Memory
Provides background information on how Oracle Database XE uses memory, and explains how to adjust the amount of memory used.
Managing Database Storage
Provides background information on storage structures, and describes how to monitor used and remaining storage space.
Managing Users and Security
Explains user accounts and administrative accounts, explains how to log in as an administrator, and describes how to create, alter, drop, and otherwise manage database users accounts.
Monitoring the Database
Describes how to monitor database operations, how to obtain information to help with performance tuning, and how to kill (terminate) a database session.
Viewing Database Version and Settings
Describes how to view database version number and database settings.
Importing, Exporting, Loading, and Unloading Data
Compares the various ways to import and export data, and explains how to import and export data both with easy-to-use graphical wizards and with powerful command-line utilities. Provides examples.
Backing Up and Recovering
Describes how to back up and restore the database, how to recover dropped tables, and how to recover data that was accidentally deleted or changed.


Oracle Database Express Edition 2 Day DBA is for anyone who wants to perform common, day-to-day administrative tasks with Oracle Database Express Edition. Prior knowledge or experience with managing databases is not required. The only requirement is a basic knowledge of computers.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Related Documentation

For more information, see these Oracle resources:

For the most recent version of the Oracle Database Express Edition documentation, see the Oracle Database XE online library:


The following text conventions are used in this document:

Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in the text or a glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.