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
- See also user accounts
- user privileges, 7.1.1
- users
-
- authenticating, 7.2.3
- creating, 7.5.2
- expiring passwords for, 7.5.5
- See also user accounts
- viewing, 7.5.1
- USERS tablespace, 6.1.2
- users.dbf datafile, 6.4
- utilities
-
- Oracle, 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