Index

@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

@

A

• abort, shutting down an instance
• access
  • database
    • database administrator account
    • granting privileges
    • restricting
    • revoking privileges
  • data
    • system privileges
  • object
    • privilege types
    • revoking privileges
• accounts
  • operating-system
    • role identification
  • user
• active extents
• Add Datafiles to Tablespace dialog
• Add Online Redo Log Group dialog box
• Add Online Redo Log Member dialog
• ADMIN OPTION
  • about
  • revoking
• AFTER triggers, auditing and
• ALERT file
  • about
  • location of
  • session high water mark in
  • size of
  • using
  • when written
• ALL_INDEXES view, filling with data
• ALL_TAB_COLUMNS view, filling with data
• ALL_TABLES view, filling with data
• allocation
  • extents
  • extents for clusters
  • minimizing extents for rollback segments
  • multi-threaded server and
  • temporary space
• alphanumeric datatypes
• ALTER CLUSTER command
  • ALLOCATE EXTENT option
  • MAXTRANS option
  • using for hash clusters
  • using for index clusters
• ALTER DATABASE command
  • ADD LOG MEMBER option
  • ADD LOGFILE option
  • ARCHIVELOG option
  • BACKUP CONTROLFILE TO TRACE option
  • CREATE DATAFILE option
  • database partially available to users
  • DATAFILE...OFFLINE DROP option
  • DROP LOGFILE MEMBER option
  • DROP LOGFILE option
  • MOUNT option
  • NOARCHIVELOG option
  • NORESETLOGS option [2] [3]
  • OPEN NORESETLOGS option
  • OPEN option
  • RENAME FILE option
  • RESETLOGS option [2] [3]
• ALTER FUNCTION command, COMPILE option
• ALTER INDEX command
  • about
  • MAXTRANS option
• ALTER PACKAGE command, COMPILE option
• ALTER PROCEDURE command, COMPILE option
• ALTER PROFILE command
  • altering resource limits
  • COMPOSITE_LIMIT option
• Alter Profile dialog
• ALTER RESOURCE COST command
• ALTER ROLE command, changing authorization method
• Alter Role dialog
• ALTER ROLLBACK SEGMENT command
  • changing storage parameters
  • OFFLINE option
  • ONLINE option [2]
  • PUBLIC option
  • STORAGE clause
• Alter Rollback Segment Storage dialog
• ALTER SEQUENCE command
• ALTER SESSION command, SET SQL_TRACE parameter
• ALTER SYSTEM command
  • ARCHIVE LOG ALL option
  • ARCHIVE LOG START option
  • ARCHIVE LOG START option, specifying destination
  • ARCHIVE LOG STOP option
  • CHECKPOINT option
  • ENABLE RESTRICTED SESSION option
  • SET LICENSE_MAX_SESSIONS option
  • SET LICENSE_MAX_USERS option
  • SET LICENSE_SESSIONS_WARNING option
  • SET MTS_DISPATCHERS option
  • SET MTS_SERVERS option
  • SET RESOURCE_LIMIT option
  • SWITCH LOGFILE option
• ALTER TABLE command
  • ALLOCATE EXTENT option
  • DISABLE ALL TRIGGERS option
  • DISABLE integrity constraint option
  • DROP integrity constraint option
  • ENABLE ALL TRIGGERS option
  • ENABLE integrity constraint option
  • example
  • MAXTRANS option
• ALTER TABLESPACE command
  • ADD DATAFILE parameter
  • BEGIN BACKUP option
    • minimizing time between begin and end
  • DEFAULT STORAGE option
  • END BACKUP option
    • minimizing time between begin and end
  • OFFLINE option
  • ONLINE option
    • example
  • READ ONLY option
  • READ WRITE option
  • RENAME DATA FILE option
• ALTER TRIGGER command
  • DISABLE option
  • ENABLE option
• ALTER USER command, changing passwords with
• Alter User dialog
• ALTER USER privilege
• ALTER VIEW command, COMPILE option
• altering
  • cluster indexes
  • clustered tables
  • clusters
  • database status
  • hash clusters
  • indexes
  • passwords
  • public rollback segments
  • rollback segment storage parameters
  • sequences
  • storage parameters
  • tables [2]
  • tablespace storage
  • users
• ANALYZE command
  • CASCADE option
  • COMPUTE STATISTICS option
  • ESTIMATE STATISTICS SAMPLE option
  • LIST CHAINED ROWS option
  • number of cluster keys
  • shared SQL and
  • STATISTICS option
  • VALIDATE STRUCTURE option
• analyzing objects
  • about
  • privileges
• application administrator
  • database administrator versus
• application developers
  • privileges for
  • roles for
• application development, security for
• ARCHIVE LOG command, LIST parameter
• archived redo log, applying during recovery [2]
  • archiving modes
  • automatic archiving
  • automatic, disabling archiving
  • default filename format
  • deleting after recovery
  • enabling automatic archiving
  • errors during recovery
  • filename format
  • listing status
  • location during recovery
  • loss of
  • preserving or resetting log sequence number [2] [3]
  • restoring to disk
  • setting archive destination
  • specifying archive destination
• ARCHIVELOG mode
  • archiving
  • datafile loss in
  • distributed database backups
  • enabling
  • setting at database creation
  • strategies for backups in
  • taking datafiles offline and online in
• archiving
  • advantages
  • automatic
    • disabling after setup
    • disabling at startup
    • enabling
  • changing mode
  • default file name format
  • disadvantages
  • enabling and disabling
  • enabling automatic
  • increasing speed of
  • manually
  • minimizing impact on system performance
  • privileges
    • enabling
    • for manually archiving
    • to view status
  • specifying destination
  • tuning
  • viewing information on
• AUDIT command
  • schema objects
  • statement auditing
  • system privileges
• audit trail
  • archiving
  • auditing changes to
  • controlling size of
  • creating and deleting
  • deleting views
  • interpreting
  • maximum size of
  • protecting integrity of
  • purging records from
  • recording changes to
  • records in
  • reducing size of
  • table that holds
  • views on
• AUDIT_TRAIL parameter, setting
• auditing
  • AUDIT command
  • audit option levels
  • audit trail records
  • default options
  • disabling default options
  • disabling options [2] [3]
  • disabling options versus auditing
  • enabling options [2]
  • enabling options versus auditing
  • guidelines
  • historical information
  • keeping information manageable
  • managing the audit trail
  • operating-system audit trails
  • policies for
  • privilege audit options
  • privileges required for object
  • privileges required for system
  • schema object types
  • schema objects
  • session level
  • shortcuts for object
  • shortcuts for system
  • statement
  • statement level
  • suspicious activity
  • system privileges
  • triggers and [2]
  • using the database
  • viewing
    • active privilege options
    • active statement options
    • defauly object options
  • views
• authentication
  • changing
  • database managed
  • multi-threaded server and
  • operating system
  • operating-system managed
  • password file
  • password policy
  • specifying when creating a user
  • users [2] [3]
• authorization
  • changing for roles
  • omitting for roles
  • operating-system role management and
  • roles
    • multi-threaded server and
• automatic archiving, archive log destination

  B

• background processes, Oracle7 processes
• BACKGROUND_DUMP_DEST parameter
• backups
  • after creating new databases
    • guidelines
  • after structural changes to database
  • ARCHIVELOG mode in
  • before database creation
  • checking datafile backup status
  • control files
  • creating a strategy
  • DB_VERIFY [2]
  • DB_VERIFY utility
  • distributed databases
  • effects of archiving on
  • Export utility and
  • frequency of
  • full backups
  • guidelines for
  • keeping
  • listing files needed
  • marking end
  • NOARCHIVELOG mode in
  • often-used tablespaces
  • partial backups
  • planning before database creation
  • privileges for control files
  • procedures for
    • offline datafiles
    • offline tablespaces
    • online datafiles
    • online tablespaces
  • read-only tablespaces
  • restoring a full backup
  • tablespaces
  • test strategies
• Begin Manual Archive dialog box
• Begin Online Tablespace Backup dialog
• branch blocks, space required
• bringing online, tablespaces
• broken jobs
  • about
  • marking
  • running
• buffers, buffer cache in SGA
• bug fixes

  C

• CASCADE option
  • integrity constraints
  • when dropping unique or primary keys
• cascading revokes
• CATAUDIT.SQL, running
• CATBLOCK.SQL script
• CATNOAUD.SQL, running
• change-based recovery, procedure for
• CHAR datatype
  • increasing column length
  • space use of [2]
• character sets
  • multi-byte characters
    • in role passwords
    • in user names
    • user passwords and
  • parameter file and
  • specifying when creating a database
  • supported by Oracle
• CHECK constraint
• checkpoint
• checkpoint process (CKPT), starting
• CHECKPOINT_PROCESS parameter, setting
• checkpoints
  • controlling
  • fast checkpoint
  • forcing
  • log switches and
  • setting intervals
• checksums
  • for data blocks
  • for redo blocks
• CKPT
• CLEAR LOGFILE clause
• clearing log files
• cluster keys
  • ANALYZE command and
  • columns for
  • SIZE parameter
• clustered tables
• clusters
  • allocating extents
  • altering
  • analyzing statistics
  • choosing data
  • columns for cluster key
  • creating
  • dropped tables and
  • dropping
  • estimating space [2] [3]
  • guidelines for managing
  • hash clusters
  • hash
  • index creation
  • index
  • indexes and
  • keys
  • location
  • managing
  • overview of
  • privileges
    • for creating
    • for dropping
  • specifying PCTFREE for
  • storage parameters
  • truncating
  • validating structure
• cold backups, full backups
• columns
  • displaying information about
  • granting privileges for selected
  • granting privileges on
  • increasing length
  • INSERT privilege and
  • listing users granted to
  • privileges
  • revoking privileges on
• complete recovery, procedures for
• composite limits
  • costs and
  • service units
• COMPUTE STATISTICS option
• configuring an instance, with dedicated server processes
• CONNECT audit option, shortcut for auditing
• CONNECT role
• connecting
  • administrator privileges
  • to a database as INTERNAL
• connections
  • auditing
  • dedicated servers
  • during shutdown
• control files
  • adding
  • backing up [2]
  • changing size
  • conflicts with data dictionary
  • creating
    • additional control files
    • initially
    • new files
  • default name [2]
  • dropping
  • during incomplete recovery [2] [3]
  • errors during creation
  • finding filenames
  • guidelines for
  • importance of mirrored
  • location of
  • loss of [2]
  • managing
  • mirroring
  • moving
  • names
  • number of
  • overwriting existing
  • privileges to backup
  • relocating
  • renaming
  • requirement of one
  • size of
  • specifying names before database creation
  • unavailable during startup
  • V$BACKUP view and
• CONTROL_FILES parameter
  • overwriting existing control files
  • setting [2]
    • names for
• costs, resource limits and
• CREATE CLUSTER command
  • example
  • for hash clusters
  • HASH IS option
  • HASHKEYS option
  • SIZE option [2]
• CREATE CONTROLFILE command
  • about
  • checking for inconsistencies
  • NORESETLOGS option
  • RESETLOGS option
• CREATE DATABASE command
  • CONTROLFILE REUSE option
  • example
  • MAXDATAFILES option
  • MAXLOGFILES option
  • MAXLOGMEMBERS option
• CREATE INDEX command
  • explicitly
  • ON CLUSTER option
  • temporary space required
  • UNRECOVERABLE
  • with a constraint
• CREATE PROFILE command
  • about
  • COMPOSITE_LIMIT option
• Create Profile dialog
• CREATE ROLE command
  • IDENTIFIED BY option
  • IDENTIFIED EXTERNALLY option
• CREATE ROLLBACK SEGMENT command
  • about
  • tuning guidelines
• Create Rollback Segment dialog
• CREATE SCHEMA command
  • multiple tables and views
  • privileges required
• CREATE SEQUENCE command
• CREATE SYNONYM command
• CREATE TABLE command
  • about
  • CLUSTER option
  • UNRECOVERABLE
• CREATE TABLESPACE command
  • datafile names in
  • example
• Create Tablespace dialog
• CREATE USER command
  • IDENTIFIED BY option
  • IDENTIFIED EXTERNALLY option
• CREATE VIEW command
  • about
  • OR REPLACE option
  • WITH CHECK OPTION
• creating
  • audit trail
  • cluster index
  • clustered tables
  • clusters
  • control files
  • database [2]
    • archiving mode
    • backing up the new database
    • during installation
    • executing CREATE DATABASE
    • maximum number of datafiles
    • migration from different versions
    • preparing to
    • prerequisites for
    • problems encountered while
    • steps
  • datafiles [2]
  • hash clustered tables
  • hash clusters
  • indexes
  • multiple objects
  • online redo log groups
  • parameter file
  • profiles
  • redo log members
  • rollback segments
    • specifying storage parameters
  • sequences
  • synonyms
  • tables
  • tablespaces
    • rollback segments required
  • views

  D

• data blocks
  • altering size of
  • managing space usage of
  • managing space use of
  • operating system blocks versus
  • PCTFREE storage parameter
  • PCTUSED storage parameter
  • shared in clusters
  • size of
  • verifying
• data dictionary
  • changing storage parameters
  • conflicts with control files
  • dropped tables and
  • schema object views
  • segments in the
  • setting storage parameters of
  • V$DBFILE view
  • V$DISPATCHER view
  • V$LOGFILE view
  • V$QUEUE view
• data integrity
  • integrity constraints
• database administrator
  • application administrator versus
  • initial priorities
  • operating-system account
  • password files for
  • responsibilities of
  • roles
    • for security
  • security and privileges of
  • security for
  • security officer versus [2]
  • usernames
  • utilities for
• database links
  • job queues and
  • privileges for controlling
• databases
  • administering
  • auditing
  • availability
  • backing up
    • full backups
  • checking the default instance
  • control files of
  • CREATE DATABASE command
  • creating
    • opening and
    • steps for
    • trouble-shooting problems
  • design of
  • dropping
  • exclusive mode
  • global database name
  • global database names
  • hardware evaluation
  • logical structure of
  • managing
  • migration of
  • mounting a database
  • mounting to an instance
  • names
    • conflicts in
  • name
  • opening
  • parallel mode
  • physical structure of
  • planning
  • production [2]
  • renaming
  • restricting access to [2]
  • shutting down
  • specifying control files
  • starting up
    • general procedures for
    • parameter filenames
    • restricting access
  • structure of
  • test
  • tuning
    • responsibilities for
  • user responsibilities
  • viewing datafiles and redo log files
• datafiles
  • adding to a tablespace
  • backing up offline
  • backing up online
  • bringing online and offline
  • checking associated tablespaces
  • creating
  • database administrator's access to
  • default directory
  • dropping
    • NOARCHIVELOG mode
  • FILEXT$
  • fully specifying filenames
  • identifying filenames
  • location
  • loss of
  • managing
  • maximum number of [2]
  • minimum number of
  • MISSING
  • monitoring
  • offline
  • online
  • privileges to rename
  • privileges to take offline
  • recovering without a backup
  • recovery creation
  • relocating [2]
  • relocating, example
  • renaming [2]
  • renaming for single tables
  • reusing
  • size of
  • storing separately from redo log files
  • unavailable when database is opened
  • verifying data blocks
  • viewing
    • files needing recovery
    • general status of
    • V$DBFILE and V$LOGFILE views
• data, security of
• datatypes
  • character
  • DATE
  • individual type names
  • LONG
  • LONG RAW
  • MLSLABEL
  • NUMBER
  • RAW
  • ROWID
  • space use of
  • summarized
• DATE datatype
• DB_BLOCK_BUFFERS parameter, setting before database creation
• DB_BLOCK_CHECKSUM
• DB_BLOCK_SIZE parameter
  • database buffer cache size and
  • setting before creation
• DB_DOMAIN parameter, setting before database creation [2]
• DB_FILES parameter
  • default
  • optional use of
• DB_NAME parameter
  • MTS_SERVICE and
  • setting before database creation
• DBA
• DBA audit option shortcuts
• DBA role [2]
• DBA_DATA_FILES [2]
• DBA_EXTENTS
• DBA_FREE_SPACE [2]
• DBA_FREE_SPACE_COALESCED view
• DBA_INDEXES view, filling with data
• DBA_ROLLBACK_SEGS view [2]
• DBA_SEGMENTS [2]
• DBA_TAB_COLUMNS view, filling with data
• DBA_TABLES view, filling with data
• DBA_TABLESPACES [2]
• DBA_TABLESPACES view
• DBA_TS_QUOTAS [2]
• DBA_USERS [2]
• DBMS_JOB package
  • altering a job
  • forcing jobs to execute
  • job queues and
  • REMOVE procedure and
  • submitting jobs
• DBMS_UTILITY.ANALYZE_SCHEMA(), running
• dedicated server processes
  • configuring
  • connecting with
  • trace files for
• dedicated servers, multi-threaded servers contrasted with
• default
  • archive log filename format
  • audit options
    • disabling
  • profile
  • role
  • tablespace quota
  • temporary tablespace
  • user tablespaces
• deleting, table statistics
• dependencies, displaying
• developers, application
• disabling
  • archiving
  • audit options [2]
  • auditing
  • automatic archiving
  • integrity constraints
    • effects on indexes
  • resource limits
  • triggers
• disconnections, auditing
• dispatcher processes
  • calculating maximum number of
  • number to start
  • privileges to change number of
  • removing
  • service name
  • setting the number of
  • spawning new
• distributed databases
  • coordinated time-based recovery
  • media recovery and snapshots
  • recovery in
  • running in ARCHIVELOG mode
  • running in NOARCHIVELOG mode
  • starting a remote instance
  • taking backups
• distributed processing, parameter file location in
• distributing I/O
• DROP CLUSTER command
  • CASCADE CONSTRAINTS option
  • dropping
    • hash cluster
  • INCLUDING TABLES option
• DROP INDEX command
• Drop Online Redo Log dialog
• Drop Online Redo Log Member dialog box
• DROP PROFILE command
• Drop Profile dialog
• DROP ROLE command [2]
• DROP ROLLBACK SEGMENT command
• Drop Rollback Segment dialog
• DROP SYNONYM command
• DROP TABLE command
  • about
  • CASCADE CONSTRAINTS option
  • for clustered tables
• DROP TABLESPACE command
• Drop Tablespace dialog box
• DROP USER command
• Drop User dialog
• DROP USER privilege
• dropping
  • audit trail
  • cluster indexes
  • clusters
  • control files
  • databases
  • datafiles
  • hash clusters
  • indexes
  • integrity constraints
    • effects on indexes
  • online redo log groups
  • online redo log members
  • profiles
  • roles
  • rollback segments [2]
  • sequences
  • synonyms
  • tables
  • tablespaces
    • required privileges
  • users
  • views
• dynamic performance tables, using

  E

• enabling
  • archiving
  • auditing options
    • privileges for
  • integrity constraints
    • example
    • reporting exceptions
    • when violations exist
  • resource limits
  • triggers
• encryption, Oracle passwords
• End Online Tablespace Backup dialog
• enroll, database users
• environment of a job
• errors
  • ALERT file and
  • during startup
  • ORA-00028
  • ORA-00114
  • ORA-01090
  • ORA-01173
  • ORA-01176
  • ORA-01177
  • ORA-1215
  • ORA-1216
  • ORA-1547
  • ORA-1628 through 1630
  • snapshot too old
  • trace files and
  • when creating a database
  • when creating control file
  • while starting an instance
• ESTIMATE STATISTICS option
• estimating size
  • hash clusters
  • indexes
  • tables [2]
• evaluating, hardware for the Oracle7 Server
• example, creating constraints
• examples, altering an index
• exceptions, integrity constraints
• exclusive mode
  • of the database
  • rollback segments and
  • terminating remaining user sessions
• EXP_FULL_DATABASE role
• Export utility
  • about
  • backups and
  • read consistency and
  • restricted mode and
  • using for backup
• exporting jobs
• extents
  • allocating
    • index creation
    • tables
  • data dictionary views for
  • displaying free extents
  • displaying information on
  • dropped tables and

  F

• failures
  • media (disk)
  • media failure
• fast checkpoint
• filenames, listing
• files, OS limit on number open
• FILEXT$
• Force Checkpoint menu option
• Force Log Switch menu option
• FOREIGN KEY constraint, enabling
• fragmentation, reducing
• free space
  • coalescing
  • listing free extents
  • tablespaces and
• full backups
  • restoring
• functions, recompiling

  G

• global database name
• GRANT command
  • ADMIN option
  • GRANT option
  • object privileges
  • SYSOPER/SYSDBA privileges
  • system privileges and roles
  • when takes effect
• GRANT OPTION
  • about
  • revoking
• granting privileges and roles
  • listing grants
  • shortcuts for object privileges
  • SYSOPER/SYSDBA privileges
• group, redo log, online redo log, archived redo log
• guidelines, for managing rollback segments

  H

• hardware, evaluating
• hash clusters
  • altering
  • choosing key
  • clusters
  • controlling space use of
  • creating
  • dropping
  • estimating storage
  • example
  • managing
  • usage
• high water mark, for a session
• HOST, command in Server Manager
• hot backups, partial backups

  I

• I/O, distributing
• identification, users
• IMP_FULL_DATABASE role
• implementing database design
• Import utility
  • about
  • procedure for using
  • restricted mode and
  • using for recovery
• importing, jobs
• in-doubt transactions, rollback segments and
• incomplete recovery, procedures for
• indexes
  • altering
  • analyzing statistics
  • cluster
    • creating
    • dropping
    • managing
  • correct tables and columns
  • creating
    • explicitly
    • unrecoverably
  • disabling and dropping constraints and
  • dropped tables and
  • dropping
  • estimating size [2]
  • extent allocation for
  • guidelines for managing
  • INITRANS for
  • limiting per table
  • managing [2]
  • MAXTRANS for
  • monitoring space use of
  • overview of
  • parallelizing index creation
  • PCTFREE for
  • PCTUSED for
  • privileges
    • for controling
    • for creating
    • for dropping
  • separating from a table
  • setting storage parameters for
  • SQL*Loader and
  • storage parameters
  • tablespace for
  • temporary segments and
  • temporary space and
  • validating structure
• INITIAL storage parameter
  • altering
• initialization parameters
  • affecting sequences
  • multi-threaded server and
• initial, passwords for SYS and SYSTEM
• INITRANS storage parameter
  • altering
  • default
  • guidelines for setting
  • transaction entries and
• INSERT privilege
  • granting
  • revoking
• installation
  • and creating a database
  • Oracle7 Server
  • tuning recommendations for
• instance identifier
  • checking
  • process names and
• instance menu
  • Open option
  • prevent Connections option
• instances
  • aborting
  • default
  • shutting down immediately
  • starting
  • starting before database creation
• integrity constraints, disabling [2]
  • disabling on creation
  • dropping
  • dropping and disabling
  • dropping tablespaces and
  • enabling
  • enabling on creation
  • enabling when violations exist
  • exceptions to
  • managing
  • UTLEXCPT.SQL script
  • violations
  • when to disable
• INTERNAL date function, executing jobs and
• INTERNAL
  • alternatives to
  • connecting for shutdown
  • creating a database as
  • OSOPER and OSDBA
  • security for
  • starting an instance as
• interrupting, media recovery

  J

• job queues
  • executing jobs in
  • locks
  • multiple SNP processes and
  • privileges for using
  • removing jobs from
  • scheduling jobs
  • starting up SNP processes
  • submitting new jobs
  • viewing
• jobs
  • altering
  • broken
  • database links and
  • executing
  • exporting
  • forcing to execute
  • importing
  • INTERNAL date function and
  • job definition
  • job number
  • killing
  • managing
  • marking broken jobs
  • ownership of
  • removing from job queue
  • running broken jobs
  • scheduling
  • submitting to job queue
  • trace files
  • troubleshooting
• join view
  • DELETE statements
  • key-preserved tables in
  • mergeable
  • modifying
  • when modifiable
• JQ locks

  K

• key-preserved tables, in join views
• keys, cluster
• Kill User Session dialog
• killing, jobs

  L

• LGWR
• LICENSE_MAX_SESSIONS parameter
  • changing while instance runs
  • setting
  • setting before database creation
• LICENSE_MAX_USERS parameter
  • changing while database runs
  • setting
  • setting before database creation
• LICENSE_SESSION_WARNING parameter, setting before database creation
• LICENSE_SESSIONS_WARNING parameter
  • changing while instance runs
  • setting
• licensing, complying with license agreement [2]
  • concurrent usage
  • named user [2]
  • number of concurrent sessions
  • privileges for changing named user limits
  • privileges for changing session limits
  • session-based
  • viewing limits
• limits
  • composite limits
  • concurrent usage
  • resource limits
  • session, high water mark
• LIST CHAINED ROWS option
• listener process
  • configuration file
  • setting MTS_LISTENER_ADDRESS
• location, rollback segments
• locks
  • job queue
  • monitoring
• log sequence numbers [2]
  • preserving after recovery [2] [3]
  • requested during recovery
  • resetting to 1 [2] [3]
• log switches
  • checkpoints and
  • forcing
  • privileges
• log writer process (LGWR), trace file monitoring
• LOG_ARCHIVE_BUFFER_SIZE parameter, setting [2]
• LOG_ARCHIVE_BUFFERS parameter, setting [2]
• LOG_ARCHIVE_DEST parameter, setting
• LOG_ARCHIVE_FORMAT parameter, setting
• LOG_ARCHIVE_START parameter
  • setting [2]
• LOG_CHECKPOINT_INTERVAL parameter, setting
• LOG_CHECKPOINT_TIMEOUT parameter, setting
• LOG_FILES parameter, number of log files and
• logical structure of a database
• LONG datatype
• LONG RAW datatype

  M

• maintenance release number
• managing
  • auditing
  • cluster indexes
  • clustered tables
  • clusters
  • indexes [2]
  • jobs
  • object dependencies
  • profiles
  • roles
  • rollback segments
  • sequences
  • synonyms
  • tables
  • users
  • views [2]
• manual archiving, in ARCHIVELOG mode
• marked user session
• MAX_DUMP_FILE_SIZE parameter
• MAX_ENABLED_ROLES parameter
  • default roles and
  • enabling roles and
• MAXDATAFILES parameter
  • changing
  • optional use of
• MAXEXTENTS storage parameter
  • about
  • setting for the data dictionary
• MAXINSTANCES parameter, changing
• MAXLOGFILES parameter
  • changing
  • number of log files and
• MAXLOGHISTORY, changing
• MAXLOGMEMBERS parameter
  • changing
  • number of log files and
• MAXTRANS storage parameter
  • altering
  • default
  • guidelines for setting
  • transaction entries and
• media failure (disk failure)
  • about
  • archived redo log file loss
  • control file loss [2]
  • datafile loss
  • online redo log group loss
  • online redo log loss
• media recovery
  • applying archived redo logs
  • at instance startup
  • cancel-based
  • change-based
  • complete recovery
  • completion of [2] [3]
  • coordinated time-based distributed database
  • deciding which files need recovery
  • determining appropriate operation
  • distributed databases
  • errors with redo log files
  • guidelines and prerequisites
  • incomplete
  • interrupting
  • lost files
    • lost archived redo log files
    • lost control files
    • lost datafiles
    • lost online redo log files
  • lost mirrored control files
  • NOARCHIVELOG mode [2]
  • open database-offline tablespace
  • performing
  • requirements of incomplete [2] [3]
  • restoring
    • damaged files
    • full backups
    • to different devices
  • resuming
  • Server Manager and
  • snapshots and
  • starting
  • successfully applied redo logs
  • SYSTEM tablespace [2] [3] [4]
  • testing
  • time-based
  • undamaged tablespaces online [2]
• memory, viewing per user
• migration, database migration
• MINEXTENTS storage parameter
  • about
  • altering
• mirrored control files
  • importance of
  • loss of
• mirrored redo log files
  • location of
  • size of
• mirroring, control files
• MLSLABEL datatype
• modes
  • exclusive
  • parallel
  • restricted [2]
• modifiable join view, definition of
• modifying, a join view
• MONITOR command, ROLLBACK option
• monitoring
  • datafiles
  • locks
  • performance tables
  • processes of an instance
  • rollback segments [2]
  • tablespaces
• mounting a database
  • exclusive mode
  • parallel mode
• moving
  • control files
  • relocating
• MTS_DISPATCHERS parameter, setting initially
• MTS_LISTENER_ADDRESS parameter
  • setting
  • starting new dispatchers and
• MTS_MAX_DISPATCHERS parameter
  • setting
• MTS_MAX_SERVERS parameter, setting
• MTS_SERVERS parameter
  • minimum value
  • setting
• MTS_SERVICE parameter
  • DB_NAME parameter as default
  • setting
• multi-plex online redo logs, symmetric groups
• multi-plexing online redo log
• multi-plexing
  • online redo log
  • redo log files [2]
• multi-threaded server
  • configuring dispatchers
  • database shutdown and
  • database startup and
  • dedicated server contrasted with
  • enabling and disabling [2]
  • operating-system authentication restrictions
  • OS role management restrictions
  • restrictions on OS role authorization
  • service name
  • shared pool and
  • starting

  N

• name resolution
• named user limits
  • setting initially
• network protocol, dispatcher for each
• NEXT storage parameter
  • setting for the data dictionary
• NOARCHIVELOG mode
  • archiving
  • datafile loss
  • distributed database backups
  • partial backups and
  • setting at database creation
  • strategies for backups in
  • taking datafiles offline in
• NOAUDIT command
  • disabling audit options
  • privileges
  • schema objects
  • statements
• non-clustered tables, estimating size of
• NORESET LOGS option, backing up control file
• NOT NULL constraint
• NUMBER datatype

  O

• objects, schema
  • cascading effects on revoking
  • default tablespace for
  • granting privileges
  • in a revoked tablespace
  • owned by dropped users
  • privileges with
  • revoking privileges
• offline backups
• offline datafiles
• offline rollback segments
  • about
  • bringing online
  • when to use
• offline tablespaces
  • altering
  • priorities
  • rollback segments and
• online backups
• online datafiles
• online redo log
  • active group
  • applying during recovery
  • archived group
  • creating groups
  • creating members
  • current group
  • dropping groups
  • dropping members
  • forcing a log switch
  • guidelines for configuring
  • inactive group
  • location of
  • loss of
  • loss of all members
  • loss of group
  • loss of mirrored members
  • managing
  • moving files
  • multi-plexing
  • number of files
  • preserving or resetting log sequence number [2] [3]
  • privileges
    • dropping groups
    • dropping members
    • forcing a log switch
  • renaming files
  • renaming members
  • STALE members
  • status of members
  • storing separately from datafiles
  • unavailable when database is opened
  • viewing filenames
  • viewing information about
• online rollback segments
  • about
  • bringing rollback segments online
  • taking offline
  • when new
• online tablespaces, altering
• opening a database
  • after creation
  • mounted database
• operating system
  • accounts
  • auditing with
  • authentication
  • database administrator's requirements for
  • deleting datafiles
  • enabling and disabling roles
  • limit of number of open files
  • Oracle7 process names
  • renaming and relocating files
  • role identification
  • role management
  • roles and
  • security in
• OPS$ account, OS_AUTHENT_PREFIX parameter
• OPTIMAL storage parameter
• options of Oracle7 Server
• Oracle blocks
• Oracle Parallel Server
• Oracle7 Server processes
  • processes
    • identifying and managing
• Oracle7 Server
  • complying with license agreement
  • identifying releases
  • installing
  • options
  • processes
    • monitoring
    • operating-system names
    • service names for dispatchers
    • trace files fpr
• ORAPWD utility
• OS authentication
• OS_AUTHENT_PREFIX parameter
  • operating-system authentication and
  • setting
• OS_ROLES parameter
  • operating-system authorization and
  • REMOTE_OS_ROLES and
  • using
• OSDBA, privileges included in
• OSOPER, privileges included in
• owner of a queued job

  P

• packages
  • privileges for recompiling
  • recompiling
• parallel mode, of the database
• parallel query option
  • number of server processes
  • parallelizing index creation
  • parallelizing table creation
  • query servers
• Parallel Server
  • ALTER CLUSTER..ALLOCATE EXTENT
  • archive log file name format
  • datafile upper bound for instances
  • forcing a checkpoint for the local instance
  • licensed session limit and
  • limits on named users and
  • LOG_CHECKPOINT_TIMEOUT and
  • managing rollback segments
  • named users and
  • own rollback segments
  • sequence numbers and
  • session and warning limits
  • specifying thread for archiving
  • switching archiving modes
  • V$THREAD view
• PARALLEL_MAX_SERVERS parameter
  • parallel recovery
• PARALLEL_MIN_SERVERS parameter
• PARALLEL_SERVER_IDLE_TIME parameter
• parameter files
  • character set of
  • choosing for startup
  • creating for database creation
  • default for instance startup
  • editing
  • editing before database creation
  • individual parameter names
  • location of
  • minimum set of
  • number of
  • sample of
  • using
• partial backups
• passwords
  • altering user passwords
  • authentication file for
  • changing for roles
  • initial for SYS and SYSTEM
  • password file
    • creating
    • OS authentication
    • relocating
    • removing
    • state of
  • privileges for changing for roles
  • privileges to alter
  • roles
  • security policy for users
  • setting REMOTE_LOGIN_PASSWORD parameter
  • user authentication
• patch release number
• PCTFREE storage parameter
  • altering
  • block overhead and
  • clustered tables
  • default
  • guidelines for setting
  • how it works
  • indexes
  • non-clustered tables
  • PCTUSED and
• PCTINCREASE storage parameter
  • about
  • altering
  • setting for the data dictionary
• PCTUSED storage parameter
  • altering
  • block overhead and
  • default
  • guidelines for setting
  • how it works
  • PCTFREE and
• performance tables, dynamic performance tables
• performance
  • location of datafiles and
  • tuning archiving
• physical structure of a database
• PL/SQL program units
  • dropped tables and
  • replaced views and
• planning
  • database creation
  • relational design
  • the database
• precedence of storage parameters
• predefined roles
• prerequisites, for creating a database
• PRIMARY KEY constraint
  • disabling
  • dropping associated indexes
  • enabling
  • enabling on creation
  • foreign key references when dropped
  • indexes associated with
  • storage of associated indexes
• private
  • rollback segments
    • taking offline
  • synonyms
• privileges [2]
  • adding datafiles to a tablespace
  • adding redo log groups
  • altering
    • dispatcher privileges
    • indexes
    • named user limit
    • passwords
    • role authentication
    • rollback segments
    • sequences
    • tables
    • users
  • analyzing objects
  • application developers and
  • audit object
  • auditing system
  • auditing use of
  • backing up
  • bringing datafiles offline and online
  • bringing tablespaces online
  • cascading revokes
  • cluster creation
  • coalescing tablespaces
  • column
  • CREATE SCHEMA command
  • creating
    • roles
    • rollback segments
    • sequences
    • synonyms
    • tables
    • tablespaces
    • users
    • views
  • database administrator
  • disabling automatic archiving
  • dropping profiles
  • dropping
    • indexes
    • online redo log members
    • redo log groups
    • roles
    • rollback segments
    • sequences
    • synonyms
    • tables
    • views
  • enabling and disabling resource limits
  • enabling and disabling triggers
  • enabling automatic archiving
  • for changing session limits
  • forcing a checkpoint
  • forcing a log switch
  • granting
    • object privileges
    • required privileges
    • system privileges
  • grouping with roles
  • individual privilege names
  • job queues and
  • listing grants
  • manually archiving
  • object
  • on selected columns
  • operating system
  • policies for managing
  • recompiling packages
  • recompiling procedures
  • recompiling views
  • renaming
    • datafiles of several tablespaces
    • objects
    • redo log members
  • replacing views
  • RESTRICTED SESSION system privilege [2]
  • revoking
  • revoking object
  • revoking object privileges
  • revoking
    • GRANT OPTION
    • object privileges
    • system privileges
  • setting resource costs
  • SQL statements permitted by
  • system
  • taking rollback segments online and offline
  • taking tablespaces offline
  • truncating
  • viewing archive status
• procedures, recompiling
• processes
• PROCESSES parameter, setting before database creation
• processes, SNP background processes
• profiles
  • altering
  • assigning to users
  • composite limit
  • creating
  • default
  • disabling resource limits
  • dropping
  • enabling resource limits
  • listing
  • managing
  • privileges for dropping
  • privileges to alter
  • privileges to set resource costs
  • PUBLIC_DEFAULT
  • setting a limit to null
  • viewing
• program global area (PGA), effect of MAX_ENABLED_ROLES on
• pseudo-column
• public rollback segments
  • making available for use
  • taking offline
• PUBLIC user group
  • granting and revoking privileges to
  • procedures and
• PUBLIC_DEFAULT profile
  • dropping profiles and
  • using
• public, synonyms

  Q

• query server process, about
• quotas
  • listing
  • revoking from users
  • setting to zero
  • tablespace
  • tablespace quotas
  • temporary segments and
  • unlimited
  • viewing [2]

  R

• RAW datatype
  • about
  • VARCHAR2 and
• read consistency, Export utility and
• read-only tablespaces
  • altering to writable
  • backing up
  • creating
  • datafiles
  • on a WORM device
  • recovering
• recompiling
  • automatically
  • functions
  • packages
  • procedures
  • views
• Recover Closed Database dialog box
• RECOVER command
  • DATABASE parameter
  • DATAFILE parameter
  • TABLESPACE parameter
• Recover Offline Tablespaces dialog box
• RECOVERY_PARALLELISM parameter
• recovery
  • creating new control files
  • effects of archiving on
  • Import utility
  • media recovery
  • PARALLEL_MAX_SERVERS parameter
  • read-only tablespaces
  • setting parallelism
  • startup with automatic
• redo log files
  • archived redo log files
  • log sequence numbers of
  • multi-plexing
  • online
  • viewing
• redo log
  • archived redo log
  • online redo log
  • relocating
  • renaming
• redo records
• reducing fragmentation
• REFERENCES privilege
  • CASCADE CONSTRAINTS option
  • revoking [2]
• relational design, planning
• releases
  • checking the release number
  • identifying for Oracle7 Server
  • maintenance release number
  • patch release number
  • port-specific release number
  • versions of other Oracle software
• relocating
  • control files
  • datafiles [2]
• remote connections
  • connecting as INTERNAL
  • connecting as SYSOPER/SYSDBA
  • password files
• REMOTE_LOGIN_PASSWORDFILE parameter
• REMOTE_OS_AUTHENT parameter, setting
• REMOTE_OS_ROLES parameter, setting [2]
• RENAME command
• Rename Data File dialog
• Rename Online Redo Log Member dialog box
• renaming
  • control files
  • datafiles [2]
  • datafiles with a single table
  • online redo log members
  • schema objects
• replacing, views
• RESOURCE audit oiption, shortcut for auditing
• resource limits
  • altering in profiles
  • assigning with profiles
  • composite limits and
  • costs and
  • creating profiles and
  • disabling
  • enabling
  • privileges to enable and disable
  • privileges to set costs
  • profiles
  • PUBLIC_DEFAULT profile and
  • service units
  • setting to null
• RESOURCE role
• RESOURCE_LIMIT parameter, enabling and disabling limits
• resources, profiles
• responsibilities
  • of a database administrator
  • of database users
• restoring, full backup
• RESTRICTED SESSION privilege
  • instances in restricted mode
  • restricted mode and
  • session limits and
• restricting access to database, starting an instance
• resuming recovery
• REVOKE command
  • when takes effect
• Revoke System Privileges/Roles dialog
• revoking privileges and roles
  • on selected columns
  • REVOKE command [2]
  • shortcuts for object privileges
  • when using operating-system roles
• revoking, privileges and roles, SYSOPER/DBA privileges
• roles
  • ADMIN OPTION and
  • application developers and
  • authorization
  • backward compatibility
  • changing authorization for
  • changing passwords
  • CONNECT role
  • database authorization
  • DBA role [2]
  • default
  • dropping
  • EXP_FULL_DATABASE
  • GRANT command
  • GRANT OPTION and
  • granting
  • grouping with roles
  • IMP_FULL_DATABASE
  • listing
  • listing grants
  • listing privileges and roles in
  • management using the operating system
  • managing
  • multi-byte characters in passwords
  • multi-byte characters
  • multi-threaded server and
  • operating system granting of [2]
  • operating-system authorization
  • OS management and the multi-threaded server
  • passwords for enabling
  • predefined [2]
  • privileges
    • changing passwords
    • for creating
    • for dropping
    • granting system privileges or roles
  • RESOURCE role
  • REVOKE command
  • revoking
  • revoking ADMIN OPTION
  • security and
  • SET ROLE command
  • unique names for
  • without authorization
• rollback segments, acquiring automatically [2]
  • acquiring on startup
  • allocating
  • altering public
  • altering storage parameters
  • AVAILABLE
  • average byte size of active extents
  • average size of truncated space
  • bringing
    • online automatically
    • online when new
    • PARTLY AVAILABLE segment online
  • checking if offline
  • choosing how many
  • choosing size for
  • creating
  • creating after database creation
  • creating public and private
  • decreasing size of
  • deferred [2]
  • displaying names of all
  • displaying
    • deferred rollback segments
    • information on
    • PENDING OFFLINE segments
  • dropping
  • equally sized extents
  • explicitly assigning transactions to
  • extends
  • guidelines for managing
  • initial
  • invalid status
  • listing extents in
  • location of
  • making available for use
  • managing
  • MINEXTENTS and
  • monitoring [2]
  • OFFLINE
  • offline rollback segments
  • offline status
  • online rollback segments
  • online status
  • PARTLY AVAILABLE
  • PENDING OFFLINE
  • privileges
    • required to alter
    • required to create
    • taking online and offline
  • setting size of
  • shrinks
  • status for dropping
  • status or state
  • storage parameters
  • storage parameters and
  • SYSTEM rollback segment
  • taking offline
  • taking tablespaces offline and
  • transactions and
  • using multiple
  • wraps
• ROLLBACK_SEGMENTS parameter
  • adding rollback segments to
  • setting before database creation
• ROWID datatype
• ROWID pseudo-column
  • changes in
• rows, chaining across blocks [2] [3] [4]
  • estimating size
  • ROWID changes
  • violating integrity constraints

  S

• schema objects
  • auditing
  • creating multiple objects
  • default audit options
  • dependencies between
  • disabling audit options
  • enabling audit options on
  • listing by type
  • listing information
  • name resolution
  • privileges to access
  • privileges to rename
  • renaming [2]
• SCN
• security
  • accessing a database
  • administrator of
  • application developers and
  • auditing policies
  • authentication of users
  • data [2]
  • database administrator's responsibilities
  • database security
  • database users and
  • establishing policies
  • general users
  • multi-byte characters
    • in role passwords
    • in user names
    • in user passwords
  • operating-system role management
  • operating-system security and the database
  • policies for database administrators
  • privilege management policies
  • privileges
  • protecting the audit trail
  • REMOTE_OS_ROLES parameter
  • roles to force security
  • security officer
  • sensitivity
• segments
  • data and index
    • reducing fragmentation
  • data dictionary
  • displaying information on
  • monitoring
  • rollback
  • temporary storage parameters
• sensitivity, security
• SEQUENCE_CACHE_ENTRIES parameter
• sequences
  • altering
  • creating
  • dropping
  • initialization parameters
  • managing
  • Parallel Server and
  • privileges for altering
  • privileges for creating
  • privileges for dropping
• Server Manager
  • about
  • operating system account
  • starting
• server units, composite limits and
• servers
  • dedicated
  • multi-threaded
• service name, for dispatcher in multi-threaded server
• session limits, license, setting initially
• session monitor
• session, user
  • active
  • inactive
  • marked to be terminated
  • terminating
  • viewing terminated sessions
• sessions
  • auditing connections and disconnections
  • limits per instance
  • listing privilege domain of
  • number of concurrent sessions
  • Parallel Server session limits
  • setting maximum for instance
  • setting warning limit for instance
  • viewing current number and high water mark
  • viewing memory use
• SET ROLE command
  • how password is set
  • when using operating-system roles
• Set Rollback Segment Offline dialog
• Set Rollback Segment Online dialog
• Set Rollback Segment Storage dialog
• Set Tablespace Offline dialog
• Set Tablespace Online dialog [2]
• Set Tablespace Storage dialog box
• SET TRANSACTION command, USE ROLLBACK SEGMENT option [2]
• SGA, determing buffers in cache
• shared mode, rollback segments and
• shared pool
  • ANALYZE command and
  • multi-threaded server and
• shared server processes
  • changing the minimum number of
  • maximum number of
  • number to start initially
  • privileges to change number of
  • trace files for
• shared SQL areas, ANALYZE command and
• shortcuts
  • CONNECT, for auditing
  • object auditing
  • object privileges
  • statement level auditing options
• shrunken extents
• Shut Down menu
  • Abort Instance option
  • Immediate option
  • Normal option
• SHUTDOWN command
  • ABORT option
  • IMMEDIATE option
  • NORMAL option
• shutting down a database
• shutting down an instance
  • aborting the instance
  • connecting and
  • connecting as INTERNAL
  • example of
  • general procedures
  • immediately
  • multi-threaded server
  • normally
• size
  • clusters
  • datafile
  • hash clusters
  • indexes
  • on non-clusterd tables
  • rollback segments
• snapshot logs, storage parameters
• snapshots
  • media recovery and
  • storage parameters
  • too old
• SNP background processes
  • about
  • initialization parameters
  • job queues and
  • multiple
• software versions
• SORT_AREA_SIZE parameter, index creation and
• space management
  • PCTFREE
  • PCTUSED
• space
  • adding to the database
  • used by indexes
• SQL statements
  • disabling audit options
  • enabling audit options on
  • privileges required for
• SQL trace facility, when to enable
• SQL*Loader
  • about
  • indexes and
• SQL_TRACE parameter, trace files and
• STALE status, of redo log members
• Start Automatic Archiving dialog
• Start Up Instance dialog box
  • Force check box
  • Mount radio button
  • Nomount radio button
  • Open radio button
  • Recover checkbox
  • Restrict to DBAs check box
  • specifying a parameter file
• starting a database
  • about
  • general procedures
  • recovering during
• starting an instance
  • at database creation
  • automatically at system startup
  • connecting as INTERNAL
  • database closed and mounted
  • database name conflicts and
  • dispatcher processes and
  • enabling automatic archiving
  • examples of
  • exclusive mode
  • forcing
  • general procedures
  • mounting and opening the database
  • multi-threaded server and
  • normally
  • parallel mode
  • parameter files
  • problems encountered while
  • recovery and
  • remote instance startup
  • restricted mode
  • specifying database name
  • troubleshooting
  • with multi-threaded servers
  • without mounting a database
• starting Server Manager
• STARTUP command
  • FORCE option
  • MOUNT option
  • NOMOUNT option
  • OPEN option
  • RECOVER option [2]
  • RESTRICT option
  • specifying database name
  • specifying parameter file
• statistics, updating
• Stop Auto Archive menu option
• storage parameters
  • applicable objects
  • changing settings
  • data dictionary
  • default
  • for the data dictionary
  • INITIAL [2]
  • INITRANS [2]
  • MAXEXTENTS
  • MAXTRANS [2]
  • MINEXTENTS [2]
  • NEXT
  • OPTIMAL (in rollback segments)
  • PCTFREE
  • PCTINCREASE
  • PCTUSED
  • precedence of
  • rollback segments
  • SYSTEM rollback segment
  • temporary segments
• storage
  • altering tablespaces
  • quotas and
  • revoking tablespaces and
  • unlimited quotas
• stored procedures
  • privileges for recompiling
  • using privileges granted to PUBLIC
• stream, tape drive
• synonyms
  • creating
  • displaying dependencies of
  • dropped tables and
  • dropping
  • managing
  • private
  • privileges for creating
  • privileges for dropping
  • public
• SYS.AUD$
  • audit trail
  • creating and deleting
• SYS
  • initial password
  • objects owned
• SYSOPER/SYSDBA privileges
  • adding users to the password file
  • connecting with
  • determining who has privileges
  • granting and revoking [2]
• SYS
  • policies for protecting
  • privileges
• System Change Number (SCN)
  • checking for a datafile
  • use in distributed recovery
• System Global Area
• System Global Area (SGA)
• system identifier
• system privileges
• SYSTEM rollback segment
  • adding
  • altering storage parameters of
  • remaining online always
  • rollback segments
• SYSTEM tablespace
  • backing up
  • cannot drop
  • initial rollback segment
  • non-data dictionary tables and
  • recovery of [2]
  • restrictions on taking offline
  • when created
• system time, changing
• SYSTEM
  • initial password
  • objects owned
  • policies for protecting
  • user
• SYS, user

  T

• tables
  • allocating extents
  • altering [2]
  • analyzing statistics
  • clustered
  • clustered tables
    • creating
    • dropping
    • managing
    • privileges to drop
    • storage
  • creating
  • designing before creating
  • dropping
  • estimating initial size
  • estimating size [2]
  • guidelines for managing [2]
  • hash clustered
    • managing
  • increasing column length
  • indexes and
  • key-preserved
  • limiting indexes on
  • location
  • location of
  • managing
• tablespaces
  • adding datafiles
  • altering availability
  • altering storage settings
  • assigning defaults for users
  • assigning user quotas
  • backing up offline
  • backing up online
  • backing up several online
  • bringing online
  • checking default storage parameters
  • coalescing
  • creating
  • creating additional
  • default quota
  • default storage parameters for
  • default temporary
  • dropping
    • required privileges
  • frequency of backups
  • guidelines for managing
  • listing files of
  • listing free space in
  • location
  • managing
  • monitoring
  • privileges for creating
  • privileges to take offline
  • quotas for users
  • quotas
  • read-only
  • revoking from users
  • rollback segments required
  • setting default storage parameters for
  • SYSTEM tablespace
  • taking offline immediately
  • taking offline normal
  • taking offline temporarily
  • temporary
  • unlimited quotas
  • using multiple
  • viewing quotas [2]
  • writable
• tables
  • parallelizing creation of
  • privileges for creation
  • privileges for dropping
  • privileges to alter
  • schema of clustered
  • separating from indexes
  • specifying PCTFREE for
  • specifying tablespace [2]
  • storage parameters
  • SYSTEM tablespace and
  • temporary space and
  • transaction parameters
  • truncating
  • UNRECOVERABLE
  • validating structure
• taking offline, tablespaces
• tape drives, streaming for archiving
• temporary segments, index creation and
• temporary space, allocating
• terminating sessions
  • active sessions
  • identifying sessions
  • inactive session, example
  • inactive sessions
• terminating, a user session
• test, security for databases
• time-based recovery
  • coordinated in a distributed database
  • procedure for
• tip
  • executing OS commands within Server Manager
  • object privilege shortcut
  • shortcuts for auditing objects
  • statement auditing shortcut
• trace files
  • control file backups to
  • job failures and
  • location of
  • log writer
  • size of
  • using [2]
  • when written
• trailing nulls
• transaction entries, guidelines for storage
• TRANSACTIONS parameter, using
• TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, using
• transactions
  • assigning to specific rollback segment
  • rollback segments and
• triggers, auditing [2]
  • disabling
  • dropped tables and
  • enabling
  • examples
  • privileges for controlling
  • privileges for enabling and disabling
• TRUNCATE command
  • DROP STORAGE option
  • REUSE STORAGE option
• truncated extents
• truncating
  • clusters
  • privileges for
  • tables
• Trusted Oracle7 Server
  • auditing
  • controlling database access
  • database migration to
  • LOG_CHECKPOINT_INTERVAL and
  • managing rollback segments
  • managing tablespaces and datafiles
  • managing users and resources
  • shutting down a database
• Trusted Oracle
  • role management
  • security policies for
  • special datatypes
  • system privileges
• tuning parameters
• tuning
  • archiving
  • databases
  • initially

  U

• UNIQUE key constraints
  • disabling
  • dropping associated indexes
  • enabling
  • enabling on creation
  • foreign key references when dropped
  • indexes associated with
  • storage of associated indexes
• UNLIMITED TABLESPACE privilege
• unrecoverable indexes, indexes
• unrecoverable
  • objects and recovery
  • tables
• UPDATE privilege, revoking
• USER_DUMP_DEST parameter
• USER_EXTENTS
• USER_FREE [2]
• USER_INDEXES view, filling with data
• USER_SEGMENTS [2]
• USER_TAB_COLUMNS view, filling with data
• USER_TABLES view, filling with data
• USER_TABLESPACES [2]
• usernames, SYS and SYSTEM
• users
  • altering
  • assigning profiles to
  • assigning tablespace quotas
  • assigning unlimited quotas for
  • auhentication
  • authentication [2]
    • operating-system authentication
  • changing authentication method
  • changing default roles
  • changing passwords
  • composite limits and
  • default tablespaces
  • dropping
  • dropping profiles and
  • dropping roles and
  • end-user security policies
  • enrolling
  • identification
  • in a newly created database
  • limiting number of
  • listing
  • listing privileges granted to
  • listing roles granted to
  • managing
  • multi-byte characters
    • in passwords
  • objects after dropping
  • password security
  • policies for managing privileges
  • privileges for changing passwords
  • privileges for creating
  • privileges for dropping
  • PUBLIC group
  • security and
  • security for general users
  • session, terminating
  • specifying user names
  • tablespace quotas
  • unique user names [2]
  • viewing information on
  • viewing memory use
  • viewing tablespace quotas [2]
• utilities
  • Export
  • for the database administrator
  • Import
  • Server Manager
  • SQL*Loader
• UTLCHAIN.SQL
• UTLEXCPT.SQL, running
• UTLLOCKT.SQL script

  V

• V$ARCHIVE view
• V$BACKUP view
• V$DATABASE view
• V$DATAFILE [2]
• V$DATAFILE view
• V$DBFILE view
• V$DISPATCHER view, controlling dispatcher process load
• V$LICENSE view
• V$LOG view
  • displaying archiving status
  • online redo log and
• V$LOGFILE view
  • listing files before backup
• V$PWFILE_USERS view
• V$QUEUE view, controlling dispatcher process load
• V$RECOVERY_FILE view
• V$RECOVERY_FILE_STATUS
• V$RECOVERY_STATUS
• V$ROLLNAME, finding PENDING OFFLINE segments
• V$ROLLSTAT, finding PENDING OFFLINE segments
• V$SESSION
• V$SESSION view
• V$THREAD view
• VALIDATE STRUCTURE option
• VARCHAR2 datatype
  • space use of
• versions
  • of other Oracle software
• views
  • creating
  • creating with errors
  • displaying dependencies of
  • dropped tables and
  • dropping
  • FOR UPDATE clause and
  • managing [2]
  • ORDER BY clause and
  • privileges
  • privileges for dropping
  • privileges for recompiling
  • privileges to replace
  • recompiling
  • replacing
  • wildcards in
  • WITH CHECK OPTION
• violating integrity constraints

  W

• warning
  • archiving mode for first backup
  • changing data dictionary storage parameters
  • consistency and Export backups
  • creating a rollback segment
  • data in dropped tablespace is unrecoverable
  • datafile names missing from control file
  • disabling audit options
  • enabling auditing
  • keeping symmetric online redo log groups
  • number of control files
  • setting the CONTROL_FILES parameter
  • use mirrored control files
• wildcards, in views
• WORM devices, and read-only tablespaces
• writable tablespaces

  X

  Y

  Z