Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Documentation Topics
• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

1 Introducing Oracle Database XE

• Accessing the Database Home Page
  • Accessing the Database Home Page from the Desktop
  • Accessing the Database Home Page with Your Web Browser—Local User
  • Accessing the Database Home Page with Your Web Browser—Remote User
• Getting Help
• Navigating the Graphical User Interface
  • Navigating Using Icons or Menus
  • Navigating Using Breadcrumbs

2 Starting Up and Shutting Down

• Starting Up the Database
  • Starting Up the Database from the Desktop
  • Starting Up the Database Using SQL Command Line
• Shutting Down the Database
  • Shutting Down the Database from the Desktop
  • Shutting Down the Database Using SQL Command Line

3 Connecting to the Database

• About Local and Remote Connections
  • About Local Connections
  • About Remote Connections
• Setting Environment Variables
  • Setting Environment Variables on the Windows Platform
  • Setting Environment Variables on the Linux Platform
• Connecting Locally with SQL Command Line
• Connecting Remotely with SQL Command Line
• Environment Variables Reference for Linux

4 Managing Network Connections

• About Network Connections and the Oracle Net Listener
• Viewing Listener Status
• Stopping and Starting the Listener
• Changing Listener Port Numbers
  • Changing the Listener Port Number for Database Connection Requests
    • Example: Changing Listener Port Number for Database Connection Requests
  • Changing the Listener Port Number for HTTP Connection Requests
• Enabling Remote HTTP Connection to the Database

5 Managing Database Memory

• About Memory Management
  • Memory Allocation Overview
  • SGA Components
  • SGA and PGA Sizes
• Viewing Current Memory Allocation
• Example: Changing SGA and PGA Aggregate Sizes

6 Managing Database Storage

• About the Database Storage Structures
  • Database
  • Tablespaces
  • Datafiles and Tempfiles
  • Control File
  • Server Parameter File
  • Password File
  • Recovery-Related Structures in the Flash Recovery Area
    • Online Redo Log Files
    • Archived Redo Log Files
• Monitoring Storage Space Usage
• Compacting Storage
• Viewing Tablespaces
• Viewing Redo Log Files
• Managing the Flash Recovery Area
  • Monitoring Space in the Flash Recovery Area
  • Setting Flash Recovery Area Location and Size

7 Managing Users and Security

• About User Accounts
  • User Privileges and Roles
  • Internal User Accounts
• About Administrative Accounts and Privileges
  • The SYS and SYSTEM Users
  • The SYSDBA System Privilege
  • Operating System Authentication
• Logging In as an Administrator
  • Logging In as User SYSTEM
  • Logging In as a User with the DBA Role
  • Logging In and Connecting to the Database as SYSDBA
• Changing Administrative User Passwords
• Managing Database Users
  • Viewing Users
  • Creating Users
    • Example: Creating a User
  • Altering Users
    • Example: Altering a User
  • Locking and Unlocking User Accounts
  • Expiring a User Password
    • Example: Expiring a Password
  • Dropping Users
    • Example: Dropping a User
• User Accounts Reference
  • Predefined User Accounts
  • User Account Icons

8 Monitoring the Database

• Monitoring Sessions
  • Viewing Sessions
  • Killing (Terminating) a Session
• Monitoring System Statistics
  • Viewing System Statistics
  • Viewing the Delta in System Statistics
• Monitoring the Top SQL Statements
• Monitoring Long Operations

9 Viewing Database Version and Settings

• Viewing Database Version
• Viewing Database Settings

10 Importing, Exporting, Loading, and Unloading Data

• About Importing, Exporting, Loading, and Unloading Data
• Choosing the Right Import/Export/Load/Unload Option
• Unloading and Loading Data
  • Unloading and Loading Data with Wizards
    • Example: Unloading Data with the Unload Wizard
    • Example: Loading Data with the Load Wizard
  • Loading Data with SQL*Loader
    • Methods SQL*Loader Uses to Load Data
    • SQL*Loader Features
    • Example: Using SQL*Loader
• Exporting and Importing Data
  • Exporting and Importing with Data Pump Export and Data Pump Import
    • Example: Using Data Pump Export and Data Pump Import
  • Exporting and Importing Data with the Export and Import Utilities

11 Backing Up and Recovering

• Backing Up and Restoring the Database
  • About Backing Up and Restoring the Database
  • Enabling ARCHIVELOG Mode for Media Failure Protection
    • Viewing the Current ARCHIVELOG Mode Setting
    • Turning on ARCHIVELOG Mode
  • Backing Up the Database
  • Scheduling Automatic Backups
  • Restoring and Recovering the Database
• Viewing and Restoring Historical Data with Flashback Query
  • About Flashback Query
  • Example: Recovering Data with Flashback Query
  • Tips for Using Flashback Query
• Recovering Dropped Tables
  • About the Recycle Bin
  • Viewing Recycle Bin Contents
  • Example: Restoring a Table from the Recycle Bin
  • Purging the Recycle Bin

Index