Preface
Previous
Next
2 Day DBA > Preface
Preface |
Previous |
Next |
Welcome to Oracle Database Express Edition 2 Day DBA. This documentation provides background and how-to information for administering Oracle Database Express Edition. It contains the following 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.
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
http://www.oracle.com/accessibility/
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.
For more information, see these Oracle resources:
Oracle Database Express Edition Application Express User's Guide
Oracle Database Express Edition Installation Guide for your platform
For the most recent version of the Oracle Database Express Edition documentation, see the Oracle Database XE online library:
http://www.oracle.com/technology/xe/documentation
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. |