Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

1 Introducing Oracle Database XE

2 Starting Up and Shutting Down

• Starting Up the Database
  • Starting Up the Database from the Desktop
  • Starting Up the Database Using the SQL Command Line
• Shutting Down the Database
  • Shutting Down the Database from the Desktop
  • Shutting Down the Database Using the 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 the SQL Command Line
• Connecting Remotely with the 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

• Automatic Memory Management
• About Memory Management
  • Memory Allocation Overview
  • SGA Components
  • SGA and PGA Sizes
• Example: Changing SGA and PGA Aggregate Sizes (Advanced Users)

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
  • 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

8 Monitoring the Database

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

9 Viewing Database Version and Globalization Information

• Viewing Database Version Information
• Viewing Database Globalization Information

10 Exporting and Importing Metadata and Data

• Using SQL Developer for Exporting and Importing
  • Example: Exporting Metadata and Data for a Table
  • Example: Importing Metadata and Data Using a Script File
  • Example: Exporting Data to a Microsoft Excel File
  • Example: Importing Data from a Microsoft Excel File
• Using Other Tools for Exporting and Importing Data
  • Choosing the Right Export/Import Utility
  • 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
    • 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