Note: It is not permitted to downgrade a database from SE or EE to Oracle Database XE.
Beta Draft Index-1
Index
A
account status, viewing, 6-9 administrative user accounts, 6-3
changing passwords for, 6-7 logging in to, 6-5
SYS, 6-3 SYSTEM, 6-3
altering user account attributes, 6-13 passwords, 6-13
usernames, 6-13 attributes, user accounts
altering, 6-13 authentication
operating system, 6-4
B
backing up the database how to, 10-2 using scripts, 10-1 breadcrumbs
using to navigate the graphical user interface, 1-4
C
changing
administrative user passwords, 6-7 user account attributes, 6-13
passwords, 6-13 usernames, 6-13 client applications
connecting to the database, 1-4 client software
Instant Client, 1-4
Oracle Database Express Edition Client, 1-4 configuration settings
viewing initialization parameters, 8-1 connect strings
elements of, 1-6
connecting to Oracle Database XE, 1-4
from client applications over the network, 3-1 from your application, 1-9
using SQL*Plus, 1-5 locally, 1-5, 1-8 remotely, 1-5, 1-8
with the SYSDBA privilege, 6-4 control files, 5-2
multiplexing, 5-2 creating users, 6-11
D
data dictionary tables access to as user SYS, 6-4 Data Pump Export, 9-7 Data Pump Import, 9-7 database administration
privileges required, 6-3 database backup facility, 10-1 Database Home Page
accessing, 1-1
navigating using breadcrumbs, 1-4 database storage structures
logical, 5-1 physical, 5-1 datafiles, 5-2 DBA role security implications, 6-11 disabling HTTP connections, 3-7 dropped tables
and recycle bins, 10-3 recovering, 10-3
dropping user accounts, 6-1, 6-14
E
environment variable scripts invoking, 1-7
environment variables
and the listener on Linux, 3-3
required for connecting with Oracle utilities, 1-6 setting
on Linux, 1-6 on Windows, 1-6 using scripts to set, 1-7 expiring passwords
how to, 6-16 reasons for, 6-16 Export utility, 9-7 exporting data
summary of available methods, 9-1 with Data Pump Export, 9-7 with the Export utility, 9-7 with the Unload Wizard, 9-3
F
flash recovery area locations of, 10-1
used in database backup, 10-1 Flashback Query
tips for using, 10-5
using to retrieve historical data, 10-4 ftp connection requests for XML DB repository
and the listener, 3-2
G
graphical desktops
using to shut down the database, 2-3 using to start up the database, 2-1
H
help, online
Oracle Database XE, 1-3 historical data
retrieving with Flashback Query, 10-4 home page
for Oracle Database XE, 1-1 HR sample schema, 6-15 HR user account, 6-15 HTTP connections disabling, 3-7 reenabling, 3-7
I
Import utility, 9-7 importing datasummary of available methods, 9-1 with Data Pump Import, 9-7 with the Import utility, 9-7 with the Load Wizard, 9-4 initialization parameters
viewing, 8-1 Instant Client
accessing, 1-4 internal user accounts
SYSTEM, 6-3
L
listener
and environment variables on Linux, 3-3 and ftp connection requests, 3-2
configuration of, 3-1 port numbers
changing, 3-5 starting, 3-3 stopping, 3-4
types of requests handled by, 3-1 viewing status of, 3-2
Listener Control utility (lsnrctl), 3-2 listener.ora file
changing port numbers in, 3-6 location of, 3-5
Load Wizard
using to import data, 9-4 loading data
with SQL*Loader, 9-7 local connections
required environment variables, 1-6 locator links
using to navigate the graphical user interface, 1-4 locking user accounts, 6-15
logging in to Oracle Database XE, 1-2, 1-3 as an administrator, 1-2, 1-3, 6-5 logical storage, 5-1
M
managing database users, 6-8 memory, 4-1 memoryallocation in Oracle Database XE, 4-1 insufficient, 4-3
managing, 4-1 types of
program global area (PGA), 4-1 system global area (SGA), 4-1 monitoring the database
current sessions, 7-1 long operations, 7-2
most-used SQL statements, 7-2 system statistics, 7-2
N
navigating the Oracle Database XE graphical user interface
using breadcrumbs, 1-4
using icons or dropdown menus, 1-3 network configuration
connection requests, 3-1 network connections
and the Oracle Net Listener, 3-1
O
object privileges, 6-2
operating system authentication See OS authentication
Oracle Database Express Edition Client accessing, 1-4 Oracle Database XE home page, 1-1 online help, 1-3 Oracle HTML DB, 1-1 Oracle Net
Beta Draft Index-3
Oracle Net listener See listener
OS authentication, 6-4 user groups, 6-5
security of adding new members, 6-5
P
password file, 5-4 passwords
altering for user accounts, 6-13 PGA
See program global area physical storage, 5-1 port numbers
changing
for database connection requests, 3-5 for HTTP connection requests, 3-6 changing in listener.ora file, 3-6 on Linux, 3-2
on Windows
default for HTTP requests, 3-2 predefined roles, 6-2
predefined user accounts, 6-17 privileges
administrative, 6-3
required for database administration, 6-3 system
SYSDBA, 6-4 user, 6-2
using roles to manage, 6-2 program global area (PGA), 4-1
default size, 4-3
when to change size of, 4-3 purging the recycle bin, 10-4
R
recovering dropped tables, 10-3 recycle bin
and dropped tables, 10-3 and user access, 10-3 purging, 10-4
viewing contents of, 10-4 redo log files, 5-2
multiplexing, 5-2
reenabling HTTP connections, 3-7 remote connections
required environment variables, 1-6 to Oracle Database XE, 3-1
removing user accounts, 6-14 restoring the database
how to, 10-3 precautions, 10-3 roles, 6-2
predefined in Oracle Database XE, 6-2 using to manage user privileges, 6-2
S
sample schema, HR, 6-15
schemas, 6-1 scripts
using to back up the database, 10-1 using to set environment variables, 1-7 security
implications of DBA role, 6-11 maintaining, 6-1
server parameter file, 5-4 sessions
monitoring, 7-1
setting environment variables on Linux, 1-6
on Windows, 1-6 SGA
See system global area shutting down the database
using a graphical desktop, 2-3 using SQL*Plus, 2-3
SQL statements
viewing the most used, 7-2 SQL*Loader
using to load data, 9-7 SQL*Plus
using to shut down the database, 2-3 using to start up the database, 2-2 starting
the database
using a graphical desktop, 2-1 using SQL*Plus, 2-2 the listener, 3-4 stopping the listener, 3-4 storage logical, 5-1 physical, 5-1 SYS user, 6-3 SYSAUX tablespace, 5-4 SYSDBA system privilege, 6-4 system global area (SGA), 4-1
components, 4-2 default size, 4-3
when to change size of, 4-3 system privileges, 6-2 SYSDBA, 6-4 SYSTEM tablespace, 5-4 SYSTEM user, 6-3
T
tablespaces, 5-3 SYSAUX, 5-4 SYSTEM, 5-4 TEMP, 5-4 types of, 5-3 UNDO, 5-4 USERS, 5-4viewing information about, 5-4 TEMP tablespace, 5-4
U
undo data, 5-3 UNDO tablespace, 5-4 Unload Wizard
using to export data, 9-3 unlocking user accounts, 6-15 upgrading Oracle Database XE, 11-1 user account attributes
altering
passwords, 6-13 usernames, 6-13 user accounts
administrative, 6-3 altering attributes of, 6-13 defining user attributes, 6-1 dropping, 6-1, 6-14
HR, 6-15 internal, 6-3 locking, 6-15
predefined in Oracle Database XE, 6-17 status of, 6-9 unlocking, 6-15 user privileges, 6-2 usernames altering, 6-13 users authenticating, 6-4 creating, 6-11
expiring passwords for, 6-16 viewing, 6-8 USERS tablespace, 5-4