Index

A B C D E F G H I L M N O P R S T U V W

A

administrative user accounts, 7.2

logging in to, 7.3

SYS, 7.2.1

SYSTEM, 7.2.1

allocated space

in tablespaces, 6.4

altering user account attributes, 7.5.3

passwords, 7.5.3

user names, 7.5.3

Application Express, 1

ARCHIVELOG mode, 6.1.7.2

setting, 11.1.2, 11.1.2.2

viewing current setting, 11.1.2.1

archiving redo log files, 6.1.7.2

attributes, user accounts

altering, 7.5.3

authentication

operating system, 7.2.3

B

backing up the database

about, 11.1.1

how to, 11.1.3

scheduling, 11.1.4

script, 11.1.3

backup

retention policy, 11.1.1

script, 11.1.1

storage

automatic management of, 11.1.1

breadcrumbs

using to navigate the graphical user interface, 1.3.2

C

changing

administrative user passwords, 7.4

user account attributes, 7.5.3

passwords, 7.5.3

user names, 7.5.3

client software

Instant Client, 3.1.2

Oracle Database Express Edition Client, 3.1.2

compacting storage space, 6.3

CONNECT role, 7.1.1

connect strings

elements of, 3.1.2

connecting to Oracle Database XE

from your application, 3

using SQL Command Line

locally, 3.1.1, 3.3

remotely, 3.1.2, 3.4

with the SYSDBA privilege, 7.2.3

control file

defined, 6.1.4

control files

SQL*Loader, 10.3.2

conventional path loads

SQL*Loader utility, 10.3.2.1

CREATE TABLESPACE command, 6.1.2

creating

tablespaces, 6.1.2

users, 7.5.2

D

data dictionary tables

access to as user SYS, 7.2.2

Data Pump

purpose, 3

Data Pump Export utility, 10.4.1

dump file set, 10.4.1

Data Pump Import utility, 10.4.1

database

defined, 6.1.1

initialization parameters, 6.1.5, 9.2

settings

viewing, 9.2

version

viewing, 9.1

database administration

privileges required, 7.2

Database Home Page

accessing, 1.1

from the desktop, 1.1.1

with Web browser from a remote computer, 1.1.3

with Web browser from the local computer, 1.1.2

enabling for remote users, 4.5

navigating using breadcrumbs, 1.3.2

database storage structures

logical, 6.1

physical, 6.1

datafile

defined, 6.1.3

DBA role, 7.1.1

security implications, 7.5.2

direct path loads

SQL*Loader utility, 10.3.2.1

directory object, 10.4.1

dropped tables

and the recycle bin, 11.3

recovering, 11.3

dropping user accounts, 7.1, 7.5.6

E

enabling

Oracle Database XE graphical user interface for remote computers, 4.5

environment variables

and the listener on Linux, 4.2

required for connecting with Oracle utilities, 3.5

scripts, 3.5, 3.5

invoking, 3.5

setting

on Linux, 3.2.2

on Windows, 3.2.1

using scripts to set, 3.5

expiring passwords

how to, 7.5.5.1

reasons for, 7.5.5

Export utility, 10.4.2

purpose, 3

exporting data, 10.1

summary of available methods, 10.2

with Data Pump Export, 10.4.1

with the Export utility, 10.4.2

external table load

SQL*Loader utility, 10.3.2.1

F

filtering data

using Data Pump Export utility, 10.4.1

flash recovery area

defined, 6.1.7

location of, 6.1.7

managing, 6.6

monitoring space in, 6.6.1

setting location, 6.6.2

setting size, 6.6.2

structures in, 6.1.7

Flashback Query

tips for using, 11.2.3

using to retrieve historical data, 11.2.1

ftp connection requests for XML DB repository

and the listener, 4.1

G

graphical user interface

enabling for remote users, 4.5

H

Help, online

Oracle Database XE, 1.2

historical data

retrieving with Flashback Query, 11.2.1

home page

See Database Home Page, 1.1

HR sample schema, 7.5.4

HR user account, 7.5.4

HTTP

connection requests, 4.1

enabling remote, 4.5

I

Import utility, 10.4.2

purpose, 3

importing data, 10.1

summary of available methods, 10.2

with Data Pump Import, 10.4.1

with the Import utility, 10.4.2

initialization parameters, database

changing, 6.1.5, 9.2

viewing, 6.1.5, 9.2

Instant Client

accessing, 3.1.2

internal schemas, 7.1.2

internal user accounts, 7.1.2

SYSTEM, 7.1.2

L

LD_LIBRARY_PATH environment variable, 3.5

listener

and environment variables on Linux, 4.2

and ftp connection requests, 4.1

configuration of, 4.1

port numbers

changing, 4.4

starting, 4.3

stopping, 4.3

types of requests handled by, 4.1

viewing status of, 4.2

Listener Control utility (lsnrctl), 4.2

listener.ora file

changing port numbers in, 4.4.1.1

location of, 4.4.1.1

Load wizard

using to load data, 10.3.1.2

loading data, 10.1

with SQL*Loader utility, 10.3.2

with the Load wizard, 10.3.1.2

local connections

required environment variables, 3.5

locator links

using to navigate the graphical user interface, 1.3.2

locking user accounts, 7.5.4

log writer process (LGWR)

writing to online redo log files, 6.1.7.1

logging in to Oracle Database XE, 1.1.1, 1.1.2, 1.1.3

as an administrator, 1.1.1, 1.1.2, 1.1.3, 7.3

logical storage, 6.1

M

Manage HTTP Access page, 4.5

managing

database users, 7.5

memory, 5.1.1

network connections, 4

storage, 6

memory

allocation in Oracle Database XE, 5.1.1, 5.3

insufficient, 5.1.3

managing, 5.1

types of

program global area (PGA), 5.1.1

system global area (SGA), 5.1.1

monitoring

space in flash recovery area, 6.6.1

storage space usage, 6.2

monitoring the database

current sessions, 8.1

long operations, 8.4

most-used SQL statements, 8.3

system statistics, 8.2

N

navigating the Oracle Database XE graphical user interface

using breadcrumbs, 1.3.2

using icons or menus, 1.3.1

network connections

and the Oracle Net Listener, 4.1

managing, 4

NLS_LANG environment variable, 3.5

NOARCHIVELOG mode, 6.1.7.2

O

object privileges, 7.1.1

online redo log files

defined, 6.1.7.1

operating system authentication

See OS authentication

Oracle Application Express, 1

Oracle Database Express Edition Client

accessing, 3.1.2

Oracle Database XE

online Help, 1.2

Oracle Net

used in remote connections, 4.1

Oracle Net listener

See listener

Oracle utilities, 3

ORACLE_HOME environment variable, 3.5

ORACLE_SID environment variable, 3.5

OS authentication, 7.2.3

user groups, 7.2.3

security of adding new members, 7.2.3

P

password file, 6.1.6

passwords

altering for user accounts, 7.5.3

expiring, 7.5.5

restrictions, 7.5.2.1

PATH environment variable, 3.5

PGA

See program global area

PGA Aggregate, 5.1.3

PGA Aggregate Target parameter, 5.1.3

physical storage, 6.1

port numbers

changing

for database connection requests, 4.4.1

for HTTP connection requests, 4.4.2

changing in listener.ora file, 4.4.1.1

on Linux, 4.1

on Windows

default for HTTP requests, 4.1

predefined roles, 7.1.1

predefined user accounts, 7.6.1

privileges

administrative, 7.2

object, 7.1.1

required for database administration, 7.2

system, 7.1.1

SYSDBA, 7.2.2

user, 7.1.1

using roles to manage, 7.1.1

program global area (PGA), 5.1.1

default size, 5.1.3

when to change size of, 5.1.3

purging the recycle bin, 11.3.4

R

recovering dropped tables, 11.3

recycle bin

and dropped tables, 11.3.1

purging, 11.3.4

viewing contents of, 11.3.2

redo log

and data protection, 6.1.7.2

ARCHIVELOG mode, 6.1.7.2

archiving, 6.1.7.2

NOARCHIVELOG mode, 6.1.7.2

redo log files

circular use of, 6.1.7.1

defined, 6.1.7.1

in the flash recovery area, 6.1.7

LGWR and the, 6.1.7.1

moving, 6.6.2

online

defined, 6.1.7.1

viewing, 6.5

remote connections

about, 3.1.2

required environment variables, 3.5

removing user accounts, 7.5.6

RESOURCE role, 7.1.1

restore

script, 11.1.1

restoring the database

about, 11.1.1

retention policy, backup, 11.1.1

roles, 7.1.1

predefined, 7.1.1

using to manage user privileges, 7.1.1

S

sample schema, HR, 7.5.4

schemas, 7.1

internal, 7.1.2

scripts

backup of the database, 11.1.3

scheduling, 11.1.4

using to set environment variables, 3.5

security

implications of DBA role, 7.5.2

maintaining, 7

server parameter file, 6.1.5

sessions

monitoring, 8.1

setting environment variables

on Linux, 3.2.2

on Windows, 3.2.1

SGA

See system global area

SGA Target parameter, 5.1.3

SHUTDOWN ABORT command, 2.2.2

SHUTDOWN IMMEDIATE command, 2.2.2

shutting down

the database

from the desktop, 2.2.1

using SQL Command Line, 2.2.2

space

compacting, 6.3

monitoring, 6.2

SQL Command Line

connecting using

locally, 3.1.1

remotely, 3.1.2

purpose, 3

using to shut down the database, 2.2.2

using to start up the database, 2.1.2

SQL statements

viewing the most used, 8.3

SQL*Loader utility

control files, 10.3.2

conventional path method, 10.3.2.1

direct path method, 10.3.2.1

discarded records, 10.3.2

external tables method, 10.3.2.1

features of, 10.3.2.2

purpose, 3

rejected records, 10.3.2

using to load data, 10.3.2

SQL*Plus

See SQL Command Line

SQLPATH environment variable, 3.5

starting

the database

from the desktop, 2.1.1

using SQL Command Line, 2.1.2

the listener, 4.3

stopping

the database

from the desktop, 2.2.1

using SQL Command Line, 2.2.2

the listener, 4.3

storage

compacting, 6.3

logical, 6.1

managing, 6

monitoring space usage, 6.2

physical, 6.1

SYS user, 7.2.1

SYSAUX tablespace, 6.1.2

SYSDBA system privilege, 7.2.2

system global area (SGA), 5.1.1

components, 5.1.2

default size, 5.1.3

when to change size of, 5.1.3

system privileges, 7.1.1

SYSDBA, 7.2.2

SYSTEM tablespace, 6.1.2

SYSTEM user, 7.2.1

T

tablespaces

creating new, 6.1.2

defined, 6.1.2

SYSAUX, 6.1.2

SYSTEM, 6.1.2

TEMP, 6.1.2

types of, 6.1.2

UNDO, 6.1.2

USERS, 6.1.2

viewing, 6.4

TEMP tablespace, 6.1.2

U

undo data, 6.1.2

UNDO tablespace, 6.1.2

Unload wizard

using to unload data, 10.3.1.1

unloading data, 10.1

with the Unload wizard, 10.3.1.1

unlocking user accounts, 7.5.4

user account attributes

altering

passwords, 7.5.3

user names, 7.5.3

user accounts

administrative, 7.2

altering attributes of, 7.5.3

defining user attributes, 7.1

dropping, 7.1, 7.5.6

HR, 7.5.4

internal, 7.1.2, 7.1.2

locking, 7.5.4

predefined in Oracle Database XE, 7.6.1

unlocking, 7.5.4

user names

altering, 7.5.3

V

version, database

viewing, 9.1

viewing

database settings, 9.2

database version, 9.1

listener status, 4.2

recycle bin contents, 11.3.2

redo log files, 6.5

tablespaces, 6.4

users, 7.5.1

W

Web applications

creating, 1