Index

ALL_TAB_COLUMNS view

ALL_TABLES view

minimizing extents for rollback segments, 18-13

allocation

extents, 12-9

extents for clusters, 15-9

multi-threaded server and, 4-5

temporary space, 12-6

alphanumeric datatypes, 10-17

ALTER CLUSTER command

ALLOCATE EXTENT option, 15-10

MAXTRANS option, 10-9

using for hash clusters, 16-10

using for index clusters, 15-9

ALTER DATABASE command

ADD LOG MEMBER option, 5-6

ADD LOGFILE option, 5-5

ARCHIVELOG option, 23-5

database partially available to users, 3-6

DATAFILE...OFFLINE DROP option, 9-8

DROP LOGFILE MEMBER option, 5-10

DROP LOGFILE option, 5-9

MOUNT option, 3-7

NOARCHIVELOG option, 23-5

OPEN option, 3-7

RENAME FILE option

datafiles for multiple tablespaces, 9-10

ALTER FUNCTION command

MOVE PARTITION clause, 11-5

ALTER INDEX command, 11-11

about, 14-9

MAXTRANS option, 10-9

REBUILD PARTITION clause, 11-5, 11-16

ALTER PACKAGE command

ALTER PROCEDURE command

altering resource limits, 20-20

ALTER PROFILE command

COMPOSITE_LIMIT option, 20-20

Alter Profile dialog, 20-20

ALTER RESOURCE COST command, 20-21

ALTER ROLE command

changing authorization method, 21-15

Alter Role dialog, 21-15

ALTER ROLLBACK SEGMENT command

changing storage parameters, 18-9

OFFLINE option, 18-12

ONLINE option, 18-11, 18-12

PUBLIC option, 18-10

STORAGE clause, 18-9

Alter Rollback Segment Storage dialog, 18-9

ALTER SEQUENCE command, 13-11

ALTER SESSION command

SET SQL_TRACE parameter, 4-14

ALTER SYSTEM command

ARCHIVE LOG ALL option, 23-8

ARCHIVE LOG START option, specifying destination, 23-13

ARCHIVE LOG STOP option, 23-7

CHECKPOINT option, 5-13

ENABLE RESTRICTED SESSION option, 3-8

SET LICENSE_MAX_SESSIONS option, 20-5

SET LICENSE_MAX_USERS option, 20-6

SET LICENSE_SESSIONS_WARNING option, 20-5

SET MTS_DISPATCHERS option, 4-10

SET MTS_SERVERS option, 4-10

SET RESOURCE_LIMIT option, 20-22

SWITCH LOGFILE option, 5-13

ALTER TABLE command

ADD PARTITION clause, 11-5

ALLOCATE EXTENT option, 12-9

DISABLE ALL TRIGGERS option, 17-13

DISABLE integrity constraint option, 17-21

DROP integrity constraint option, 17-23

DROP PARTITION clause, 11-6

ENABLE ALL TRIGGERS option, 17-13

ENABLE integrity constraint option, 17-21, 17-22

example, 12-8

MAXTRANS option, 10-9

MODIFY PARTITION clause, 11-4

SPLIT PARTITION clause, 11-5, 11-10

TRUNCATE PARTITION clause, 11-8

ALTER TABLESPACE command

ADD DATAFILE parameter, 9-5

ONLINE option

example, 8-8

READ ONLY option, 8-11

READ WRITE option, 8-13

RENAME DATA FILE option, 9-9

ALTER TRIGGER command

DISABLE option, 17-13

ENABLE option, 17-13

ALTER USER command

changing passwords with, 20-17

Alter User dialog, 20-16

ALTER USER privilege, 20-16

ALTER VIEW command

public rollback segments, 18-10

altering

cluster indexes, 15-9

clustered tables, 15-9

rollback segment storage parameters, 18-9

sequences, 13-11

storage parameters, 12-8

tables, 12-7, 12-8

tablespace storage, 8-6

users, 20-16

ANALYZE command

CASCADE option, 17-9

COMPUTE STATISTICS option, 17-7

ESTIMATE STATISTICS SAMPLE option, 17-8

LIST CHAINED ROWS option, 17-9

number of cluster keys, A-15

shared SQL and, 17-8

STATISTICS option, 17-4

VALIDATE STRUCTURE option, 17-9

analyzing objects

about, 17-3

privileges, 17-3

application administrator, 1-3

database administrator versus, 19-11

application developers

privileges for, 19-9

roles for, 19-10

application development

security for, 19-9

applications

quiescing during maintenance operations, 11-17

ARCHIVE LOG command

LIST parameter, 5-8

archived redo log

archiving modes, 23-5

automatic archiving, 23-6

automatic, disabling archiving, 23-7

enabling automatic archiving, 23-6

filename format, 23-12

listing status, 23-10

setting archive destination, 23-13

specifying archive destination, 23-12

ARCHIVELOG mode

archiving, 23-2

enabling, 23-5

setting at database creation, 23-4

taking datafiles offline and online in, 9-8

archiving

advantages, 23-2

automatic

disabling, 23-7

disabling after setup, 23-7

disabling at startup, 23-7

enabling, 23-6

changing mode, 23-5

disadvantages, 23-2

enabling and disabling, 23-4

enabling automatic, 23-6

increasing speed of, 23-10

manually, 23-8

minimizing impact on system performance, 23-9

privileges

disabling, 23-7

enabling, 23-6

for manually archiving, 23-8

specifying destination, 23-12

tuning, 23-9

viewing information on, 23-10

AUDIT command, 22-10

schema objects, 22-11

statement auditing, 22-10

system privileges, 22-10

audit trail, 22-14

archiving, 22-15

auditing changes to, 22-17

controlling size of, 22-14

creating and deleting, 22-4

deleting views, 22-5

interpreting, 22-17

maximum size of, 22-15

protecting integrity of, 22-17

purging records from, 22-15

recording changes to, 22-17

records in, 22-7

reducing size of, 22-16

table that holds, 22-2

views on, 22-4

AUDIT_TRAIL parameter

setting, 22-14

auditing, 22-2

AUDIT command, 22-10

audit option levels, 22-8

audit trail records, 22-5

default options, 22-11

disabling default options, 22-13

disabling options, 22-12, 22-13

disabling options versus auditing, 22-12

enabling options, 22-10, 22-13

enabling options versus auditing, 22-10

guidelines, 22-2

historical information, 22-4

keeping information manageable, 22-2

managing the audit trail, 22-4

operating-system audit trails, 22-7

policies for, 19-18

privilege audit options, 22-9

privileges required for object, 22-11

privileges required for system, 22-11

schema object types, 22-9

schema objects, 22-11

session level, 22-8

shortcuts for object, 22-10

shortcuts for system, 22-8

statement, 22-10

statement level, 22-8

suspicious activity, 22-3

system privileges, 22-10

triggers and, 22-21

using the database, 22-2

viewing

active object options, 22-19

active privilege options, 22-19

active statement options, 22-19

defauly object options, 22-20

views, 22-4

authentication

changing, 20-17

database managed, 20-8

operating system, 1-7

password file, 1-9

password policy, 19-4

specifying when creating a user, 20-13

users, 19-2, 20-7, 20-10

authorization

changing for roles, 21-15

omitting for roles, 21-14

operating-system role management and, 21-14

roles

about, 21-13

multi-threaded server and, 21-14

automatic archiving

archive log destination, 23-6

background processes

Oracle7 processes, 4-13

BACKGROUND_DUMP_DEST parameter, 4-15

backups

after creating new databases

full backups, 2-7

guidelines, 1-20

before database creation, 2-4

effects of archiving on, 23-2

Begin Manual Archive dialog box, 23-8

branch blocks

space required, A-9

bringing online

tablespaces, 8-8

broken jobs

about, 7-14

marking, 7-14

running, 7-15

buffers

buffer cache in SGA, 2-11

bug fixes, 1-21

CASCADE option

integrity constraints, 15-11

when dropping unique or primary keys, 17-21

cascading revokes, 21-21

CATAUDIT.SQL

running, 22-4

CATBLOCK.SQL script, 4-12

CATNOAUD.SQL

running, 22-5

CHAR datatype

increasing column length, 12-8

space use of, 10-17

character sets

multi-byte characters

in role names, 21-11

in role passwords, 21-13

in user names, 20-13

user passwords and, 20-13

parameter file and, 3-13

specifying when creating a database, 2-2

supported by Oracle, 10-17

CHECK constraint, 17-20

checkpoint process (CKPT)

starting, 4-16

CHECKPOINT_PROCESS parameter

setting, 4-16

checkpoints

controlling, 5-10

fast checkpoint, 5-13

forcing, 5-13

log switches and, 5-10

setting intervals, 5-11

checksums

for data blocks, 9-12

for redo blocks, 5-13

CKPT, 4-16

CLEAR LOGFILE clause, 5-14

clearing log files, 5-14

cluster keys

ANALYZE command and, A-15

columns for, 15-4

SIZE parameter, 15-5

clustered tables, 15-10

clusters

columns

displaying information about, 17-34

granting privileges for selected, 21-17

granting privileges on, 21-18

increasing length, 12-8

INSERT privilege and, 21-18

listing users granted to, 21-29

privileges, 21-18

revoking privileges on, 21-20

composite limits, 20-20

costs and, 20-21

service units, 20-20

COMPUTE STATISTICS option, 17-7

configuring an instance

with dedicated server processes, 4-2

CONNECT role, 21-12

connecting

administrator privileges, 3-9

to a database as INTERNAL, 3-2

connections

auditing, 22-8

dedicated servers, 4-3

during shutdown, 3-8

control files

CONTROL_FILES parameter

overwriting existing control files, 2-10

setting

before database creation, 2-10, 6-4

names for, 6-2

costs

resource limits and, 20-21

CREATE CLUSTER command

example, 15-7

for hash clusters, 16-5

HASH IS option, 16-6

HASHKEYS option, 16-7

SIZE option, 16-6, A-14

CREATE CONTROLFILE command

about, 6-5

checking for inconsistencies, 6-8

NORESETLOGS option, 6-7

RESETLOGS option, 6-6

CREATE DATABASE command

CONTROLFILE REUSE option, 6-4

example, 2-7

MAXLOGFILES option, 5-4

MAXLOGMEMBERS option, 5-4

CREATE INDEX command

explicitly, 14-8

ON CLUSTER option, 15-8

temporary space required, A-10

UNRECOVERABLE, 14-5

with a constraint, 14-7

CREATE PROFILE command

about, 20-19

COMPOSITE_LIMIT option, 20-20

Create Profile dialog, 20-19

CREATE ROLE command

IDENTIFIED BY option, 21-13

IDENTIFIED EXTERNALLY option, 21-14

CREATE ROLLBACK SEGMENT command

about, 18-8

tuning guidelines, 2-15

Create Rollback Segment dialog, 18-8

CREATE SCHEMA command

multiple tables and views, 17-2

privileges required, 17-2

CREATE SEQUENCE command, 13-10

CREATE SYNONYM command, 13-12

CREATE TABLE command

about, 12-7

CLUSTER option, 15-7

PARTITION clause, 11-2

UNRECOVERABLE, 12-4

CREATE TABLESPACE command

datafile names in, 8-4

example, 8-4

Create Tablespace dialog, 8-4

CREATE USER command

IDENTIFIED BY option, 20-13

IDENTIFIED EXTERNALLY option, 20-13

CREATE VIEW command

about, 13-2

OR REPLACE option, 13-9

WITH CHECK OPTION, 13-3

creating

audit trail, 22-4

cluster index, 15-7

clustered tables, 15-7

backing up the new database, 2-7

during installation, 2-3

executing CREATE DATABASE, 2-6

migration from different versions, 2-3

preparing to, 2-2

prerequisites for, 2-3

problems encountered while, 2-8

datafiles, 8-3, 9-5

hash clustered tables, 16-5

hash clusters, 16-5

indexes

explicitly, 14-8

multiple objects, 17-2

online redo log groups, 5-5

parameter file, 2-4

partitioned objects, 11-2

partitioned tables, 11-2

profiles, 20-19

redo log members, 5-6

rollback segments

about, 18-8

specifying storage parameters, 18-8

rollback segments required, 8-5

views, 13-2

data

security of, 19-3

data blocks

altering size of, 2-11

managing space usage of, 10-2

managing space use of, 10-2

operating system blocks versus, 2-11

PCTFREE storage parameter, 10-3

PCTUSED storage parameter, 10-5

shared in clusters, 15-2

size of, 2-11

verifying, 9-12

data dictionary

changing storage parameters, 17-31

conflicts with control files, 6-8

setting storage parameters of, 17-29

schema object views, 17-32

segments in the, 17-29

V$DBFILE view, 2-8

V$DISPATCHER view, 4-10

V$LOGFILE view, 2-8

V$QUEUE view, 4-10

data integrity, 17-20

integrity constraints, 17-20

database administrator, 1-2

application administrator versus, 19-11

initial priorities, 1-18

operating-system account, 1-4

password files for, 1-7

responsibilities of, 1-2

roles

about, 1-6

for security, 19-8

security and privileges of, 1-4

security for, 19-7

security officer versus, 1-3, 19-2

usernames, 1-5

utilities for, 1-17

database links

job queues and, 7-10

privileges for controlling, 21-10

databases

administering, 1-1

auditing, 22-1

availability, 3-6

backing up

after creation of, 1-20

full backups, 2-7

control files of, 6-2

CREATE DATABASE command, 2-7

creating

opening and, 1-20

trouble-shooting problems, 2-8

design of

global database name

global database names

in a distributed system, 2-9

hardware evaluation, 1-19

logical structure of, 1-19

managing

size of, 9-1

migration of, 2-3

mounting a database, 3-3

mounting to an instance, 3-7

name

starting an instance, 3-2

names

about, 2-9

conflicts in, 2-9

opening

a closed database, 3-7

parallel mode, 3-5

physical structure of, 1-19

planning, 1-19

production, 19-9, 19-11

renaming, 6-5

restricting access to, 3-4, 3-7

shutting down, 3-8

specifying control files, 2-10

starting up

before database creation, 2-6

general procedures for, 3-2

parameter filenames, 3-3

restricting access, 3-4

structure of

distributed database, 1-19

test, 19-9

tuning

archiving large databases, 23-9

responsibilities for, 1-21

user responsibilities, 1-3

viewing datafiles and redo log files, 2-8

datafiles

datatypes

character, 10-17

DATE, 10-18

individual type names, 10-17

LONG, 10-18

DB_BLOCK_BUFFERS parameter

setting before database creation, 2-11

DB_BLOCK_CHECKSUM, 9-12

DB_BLOCK_SIZE parameter

database buffer cache size and, 2-11

setting before creation, 2-11

DB_DOMAIN parameter

setting before database creation, 2-9

DB_NAME parameter

MTS_SERVICE and, 4-6

setting before database creation, 2-9

DBA, 1-2

DBA role, 1-6, 21-12

DBA_DATA_FILES, 8-15, 9-13

DBA_EXTENTS, 9-13

DBA_FREE_SPACE, 8-15, 9-13

DBA_FREE_SPACE_COALESCED view, 8-7

DBA_INDEXES view

DBA_ROLLBACK_SEGS view, 18-15

DBA_SEGMENTS, 8-15, 9-13

DBA_TAB_COLUMNS view

DBA_TABLES view

DBA_TABLESPACES, 8-15, 9-13

DBA_TABLESPACES view, 8-14

DBA_TS_QUOTAS, 8-15, 9-13

DBA_USERS, 8-15, 9-13

DBMS_JOB package

altering a job, 7-12

forcing jobs to execute, 7-15

job queues and, 7-4

REMOVE procedure and, 7-12

submitting jobs, 7-6

DBMS_UTILITY.ANALYZE_SCHEMA()

running, 17-8

dedicated server processes

configuring, 4-2

connecting with, 4-3

trace files for, 4-14

dedicated servers

multi-threaded servers contrasted with, 4-3

default

audit options, 22-11

disabling, 22-13

profile, 20-19

role, 20-17

tablespace quota, 20-14

temporary tablespace, 20-14

user tablespaces, 20-13

deleting

table statistics, 17-4

dependencies

displaying, 17-35

developers, application, 19-9

disabling

archiving, 23-4

audit options, 22-12, 22-13

auditing, 22-13

automatic archiving, 23-7

integrity constraints, 17-19

effects on indexes, 14-6

resource limits, 20-22

triggers, 17-13

disconnections

auditing, 22-8

dispatcher processes

calculating maximum number of, 4-8

number to start, 4-7

privileges to change number of, 4-11

removing, 4-10

service name, 4-6

setting the number of, 4-10

spawning new, 4-10

distributed databases

running in ARCHIVELOG mode, 23-3

running in NOARCHIVELOG mode, 23-3

starting a remote instance, 3-6

distributed processing

parameter file location in, 3-13

distributing I/O, 2-16

DROP CLUSTER command

CASCADE CONSTRAINTS option, 15-11

dropping

cluster with no tables, 15-11

hash cluster, 16-10

INCLUDING TABLES option, 15-11

Drop Online Redo Log dialog, 5-9

Drop Online Redo Log Member dialog box, 5-10

DROP PARTITION clause

ALTER TABLE command, 11-6

DROP PROFILE command, 20-22

Drop Profile dialog, 20-22

DROP ROLE command, 21-15, 21-16

DROP ROLLBACK SEGMENT command, 18-14

Drop Rollback Segment dialog, 18-14

DROP SYNONYM command, 13-13

DROP TABLE command

about, 12-9

CASCADE CONSTRAINTS option, 12-9

for clustered tables, 15-10

DROP TABLESPACE command, 8-14

Drop Tablespace dialog box, 8-14

DROP USER command, 20-18

Drop User dialog, 20-18

DROP USER privilege, 20-18

dropping

dynamic performance tables

using, 4-13

enabling

archiving, 23-4

auditing options

about, 22-10

privileges for, 22-13

integrity constraints

at creation, 17-19

example, 17-20

reporting exceptions, 17-23

when violations exist, 17-16

resource limits, 20-22

triggers, 17-13

encryption

Oracle passwords, 20-8

enroll

database users, 1-21

Enterprise, 1-17

Enterprise Manager

operating system account, 1-4

Enterpsie Manager, 1-17

environment of a job, 7-7

errors

ORA-1628 through 1630, 17-31

snapshot too old, 18-6

trace files and, 4-14

when creating a database, 2-8

when creating control file, 6-9

while starting an instance, 3-5

ESTIMATE STATISTICS option, 17-7

estimating size

hash clusters, 16-4

tables, 12-5, A-5

evaluating

hardware for the Oracle7 Server, 1-19

example

creating constraints, 17-20

examples

altering an index, 14-9

exceptions

integrity constraints, 17-23

exclusive mode

of the database, 3-5

rollback segments and, 18-3

terminating remaining user sessions, 4-20

EXP_FULL_DATABASE role, 21-12

Export utility

about, 1-17

restricted mode and, 3-4

exporting jobs, 7-8

extents

allocating

clusters, 15-9

index creation, 14-6

tables, 12-9

data dictionary views for, 17-33

displaying free extents, 17-36

displaying information on, 17-35

OS limit on number open, 8-2

fast checkpoint, 5-13

files

Force Checkpoint menu option, 5-13

Force Log Switch menu option, 5-13

FOREIGN KEY constraint

enabling, 17-20

free space

coalescing, 8-6

listing free extents, 17-36

tablespaces and, 8-17

functions

dropping partition with, 11-6, 11-9

global database name, 2-9

global index

splitting partition in, 11-11

global user, 20-11

GRANT command

ADMIN option, 21-16

GRANT option, 21-18

object privileges, 21-17

SYSOPER/SYSDBA privileges, 1-13

system privileges and roles, 21-16

when takes effect, 21-22

GRANT OPTION

about, 21-18

shortcuts for object privileges, 21-10

granting privileges and roles

listing grants, 21-26

SYSOPER/SYSDBA privileges, 1-13

guidelines

for managing rollback segments, 18-2

hardware

hash clusters

controlling space use of, 16-5

creating, 16-5

dropping, 16-10

estimating storage, 16-4

high water mark

historical table

moving time window in, 11-16

HOST

command in Server Manager, 5-7

I/O

distributing, 2-16

identification

users, 20-8

IMP_FULL_DATABASE role, 21-12

implementing database design, 1-20

Import utility

about, 1-17

restricted mode and, 3-4

importing

index partition

indexes

adding partition, 11-5

altering, 14-9

analyzing statistics, 17-3

cluster

correct tables and columns, 14-7

creating

after inserting table data, 14-3

explicitly, 14-8

unrecoverably, 14-5

disabling and dropping constraints and, 14-6

extent allocation for, 14-6

dropping, 14-10

estimating size, 14-5

guidelines for managing, 14-2

INITRANS for, 14-4

limiting per table, 14-3

managing, 14-1, 14-10

MAXTRANS for, 14-4

monitoring space use of, 14-9

overview of, 14-2

parallelizing index creation, 14-5

PCTFREE for, 14-4

PCTUSED for, 14-4

privileges

for altering, 14-9

for controling, 21-10

for dropping, 14-10

separating from a table, 12-6

setting storage parameters for, 14-5

SQL*Loader and, 14-3

temporary segments and, 14-3

tablespace for, 14-4

temporary space and, A-10

validating structure, 17-9

index-organized table, 12-10

in-doubt transactions

rollback segments and, 18-12

initial

passwords for SYS and SYSTEM, 1-5

INITIAL storage parameter, 10-7

multi-threaded server and, 4-5

initialization parameters

affecting sequences, 13-11

INITRANS storage parameter

guidelines for setting, 10-9

default, 10-9

transaction entries and, 10-9

INSERT privilege

granting, 21-18

and creating a database, 2-3

installation

Oracle7 Server, 1-18

tuning recommendations for, 2-14

instance identifier

process names and, 4-14

instance menu

Open option, 3-7

prevent Connections option, 3-8

instances

aborting, 3-12

shutting down immediately, 3-11

starting, 3-2

starting before database creation, 2-6

integrity constraints

disabling, 17-14, 17-20

disabling on creation, 17-19

dropping, 17-23

dropping and disabling, 14-6

dropping tablespaces and, 8-14

enabling, 17-15

enabling on creation, 17-19

enabling when violations exist, 17-16

exceptions to, 17-23

managing, 17-16

violations, 17-16

when to disable, 17-16

INTERNAL

alternatives to, 1-8

connecting for shutdown, 3-9

creating a database as, 2-6

OSOPER and OSDBA, 1-8

security for, 19-7

starting an instance as, 3-2

INTERNAL date function

executing jobs and, 7-9

job queues, 7-2

, 7-3

executing jobs in, 7-10

locks, 7-11

privileges for using, 7-4

removing jobs from, 7-12

scheduling jobs, 7-4

viewing, 7-16

jobs

join view, 13-4

DELETE statements, 13-7

key-preserved tables in, 13-5

mergeable, 13-5

modifying

rule for, 13-6

when modifiable, 13-4

JQ locks, 7-11

key-preserved tables

in join views, 13-5

keys

cluster, 15-2

Kill User Session dialog, 4-20

killing

jobs, 7-16

LGWR, 4-15

LICENSE_MAX_SESSIONS parameter

changing while instance runs, 20-5

setting, 20-4

changing while database runs, 20-6

LICENSE_MAX_USERS parameter

setting, 20-6

LICENSE_SESSION_WARNING parameter

changing while instance runs, 20-5

LICENSE_SESSIONS_WARNING parameter

setting, 20-4

licensing

complying with license agreement, 2-12, 20-2

concurrent usage, 20-2

named user, 20-2, 20-5

number of concurrent sessions, 2-13

privileges for changing named user limits, 20-6

privileges for changing session limits, 20-5

session-based, 20-2

viewing limits, 20-7

limits

composite limits, 20-20

concurrent usage, 20-2

resource limits, 20-20

session, high water mark, 20-3

LIST CHAINED ROWS option, 17-9

listener process

configuration file, 4-6

setting MTS_LISTENER_ADDRESS, 4-5

location

rollback segments, 18-7

locks

job queue, 7-11

monitoring, 4-12

log sequence numbers, 5-2

log switches

checkpoints and, 5-10

forcing, 5-12

privileges, 5-13

log writer process (LGWR)

trace file monitoring, 4-15

LOG_ARCHIVE_BUFFER_SIZE parameter

setting, 23-9, 23-10

LOG_ARCHIVE_BUFFERS parameter

setting, 23-9, 23-10

LOG_ARCHIVE_DEST parameter

setting, 23-13

LOG_ARCHIVE_FORMAT parameter

setting, 23-12

LOG_ARCHIVE_START parameter, 23-6

setting, 23-6, 23-7

LOG_CHECKPOINT_INTERVAL parameter

setting, 5-11

LOG_CHECKPOINT_TIMEOUT parameter

setting, 5-12

LOG_FILES parameter

number of log files and, 5-4

logical structure of a database, 1-19

LONG datatype, 10-18

maintenance release number, 1-22

managing

auditing, 22-1

cluster indexes, 15-1

clustered tables, 15-1

clusters, 15-1

indexes, 14-1, 14-10

jobs, 7-4

object dependencies, 17-25

MAX_DUMP_FILE_SIZE parameter, 4-15

roles, 21-11

rollback segments, 18-1

manual archiving

in ARCHIVELOG mode, 23-8

marked user session, 4-21

MAX_ENABLED_ROLES parameter

default roles and, 21-15

enabling roles and, 21-15

MAXDATAFILES parameter

setting for the data dictionary, 17-29

MAXEXTENTS storage parameter

about, 10-8

MAXINSTANCES parameter

MAXLOGFILES parameter

number of log files and, 5-4

MAXLOGHISTORY

MAXLOGMEMBERS parameter

number of log files and, 5-4

MAXTRANS storage parameter

guidelines for setting, 10-9

default, 10-9

transaction entries and, 10-9

memory

viewing per user, 20-27

migration

database migration, 2-3

MINEXTENTS storage parameter

about, 10-8

ALTER TABLE command, 11-4

mirrored control files

importance of, 6-2

mirrored redo log files

mirroring

modes

modifiable join view

MODIFY PARTITION clause

modifying

a join view, 13-4

MONITOR command

ROLLBACK option, 18-15

monitoring

datafiles, 9-13

locks, 4-12

performance tables, 4-13

processes of an instance, 4-11

rollback segments, 18-6, 18-15

tablespaces, 9-13

mounting a database, 3-3

exclusive mode, 3-5

parallel mode, 3-5

MOVE PARTITION clause

ALTER TABLE command, 11-5

moving

control files, 6-4

index partitions, 11-5

relocating, 9-8

table partition, 11-4

MTS_DISPATCHERS parameter

setting initially, 4-7

MTS_LISTENER_ADDRESS parameter

setting, 4-5

starting new dispatchers and, 4-10

MTS_MAX_DISPATCHERS parameter, 4-8

setting, 4-8

MTS_MAX_SERVERS parameter

setting, 4-9

MTS_SERVERS parameter

minimum value, 4-9

setting, 4-9

MTS_SERVICE parameter

DB_NAME parameter as default, 4-6

setting, 4-6

multi-plex online redo logs

symmetric groups, 5-2

multi-plexing

online redo log, 5-2

redo log files, 5-2

multi-plexing online redo log, 5-2

multi-threaded server

configuring dispatchers, 4-7

database startup and, 3-2

dedicated server contrasted with, 4-3

enabling and disabling, 4-9, 4-10

OS role management restrictions, 21-26

restrictions on OS role authorization, 21-14

service name, 4-6

shared pool and, 4-5

starting, 4-5

named user limits, 20-5

setting initially, 2-13

network protocol

dispatcher for each, 4-7

NEXT storage parameter, 10-8

setting for the data dictionary, 17-29

NOARCHIVELOG mode

archiving, 23-2

setting at database creation, 23-4

taking datafiles offline in, 9-8

NOAUDIT command

disabling audit options, 22-12

privileges, 22-12

schema objects, 22-13

statements, 22-12

non-clustered tables

estimating size of, A-2

NOT NULL constraint, 17-20

NUMBER datatype, 10-17

objects, schema

cascading effects on revoking, 21-21

default tablespace for, 20-13

granting privileges, 21-17

in a revoked tablespace, 20-15

owned by dropped users, 20-17

privileges with, 21-9

revoking privileges, 21-19

offline datafiles, 9-8

offline rollback segments

about, 18-11

bringing online, 18-11

when to use, 18-11

offline tablespaces

altering, 8-8

priorities, 8-9

rollback segments and, 18-11

online datafiles, 9-8

online redo log, 5-2

online rollback segments

about, 18-11

bringing rollback segments online, 18-11

taking offline, 18-12

when new, 18-8

online tablespaces

altering, 8-8

opening a database

after creation, 1-20

mounted database, 3-7

operating system

accounts, 21-24

auditing with, 22-2

authentication, 21-23

database administratorsrequirementsfor', 1-4

deleting datafiles, 8-14

enabling and disabling roles, 21-26

limit of number of open files, 9-2

Oracle7 process names, 4-13

renaming and relocating files, 9-9

role identification, 21-24

roles and, 21-23

security in, 19-3

OPTIMAL storage parameter, 18-6

Oracle blocks, 2-11

Oracle Parallel Server, 5-12

Oracle7 Server

complying with license agreement, 20-2

identifying releases, 1-21

installing, 1-18

processes

checkpoint (CKPT), 4-16

monitoring, 4-11

operating-system names, 4-13

service names for dispatchers, 4-6

trace files fpr, 4-14

Oracle7 Server processes

processes

dedicated server processes, 4-2

identifying and managing, 4-11

ORAPWD utility, 1-9

OS authentication, 1-7

OS_ROLES parameter

operating-system authorization and, 21-14

REMOTE_OS_ROLES and, 21-26

using, 21-24

owner of a queued job, 7-8

packages

privileges for recompiling, 17-27

number of server processes, 4-17

parallel mode

of the database, 3-5

parallel query option

parallelizing index creation, 14-5

parallelizing table creation, 12-4

query servers, 4-17

Parallel Server

ALTER CLUSTER..ALLOCATE EXTENT, 15-10

archive log file name format, 23-12

datafile upper bound for instances, 9-3

forcing a checkpoint for the local instance, 5-13

licensed session limit and, 2-13

limits on named users and, 20-6

LOG_CHECKPOINT_TIMEOUT and, 5-12

named users and, 2-13

own rollback segments, 18-3

sequence numbers and, 13-11

session and warning limits, 20-4

specifying thread for archiving, 23-8

V$THREAD view, 5-15

PARALLEL_MAX_SERVERS parameter, 4-17

PARALLEL_MIN_SERVERS parameter, 4-17

PARALLEL_SERVER_IDLE_TIME parameter, 4-17

parameter files

character set of, 3-13

choosing for startup, 3-3

creating for database creation, 2-4

default for instance startup, 3-3

editing, 3-13

editing before database creation, 2-5

individual parameter names, 2-9

partition

adding to index, 11-5

dropping from index, 11-8

PARTITION clause

CREATE TABLE command, 11-2

partitioned index

merging, 11-12

rebuilding partitions, 11-16

partitioned objects, 11-1 to 11-17

adding, 11-5

creating, 11-2

definition, 11-2

maintaining, 11-3 to 11-17

merging, 11-12

moving, 11-4

quiescing applications during maintenance of, 11-17

splitting partition, 11-10

truncating, 11-8

partitioned table

adding partitions, 11-5

converting to non-partitioned, 11-13

merging partitions, 11-12, 11-13

splitting partition, 11-10

partitioned view

converting to partitioned table, 11-14

passwords

altering user passwords, 20-17

authentication file for, 1-9

changing for roles, 21-15

initial for SYS and SYSTEM, 1-5

password file

, 1-12

creating, 1-9

OS authentication, 1-7

relocating, 1-15

removing, 1-16

state of, 1-16

privileges for changing for roles, 21-13

privileges to alter, 20-16

roles, 21-13

security policy for users, 19-4

setting REMOTE_LOGIN_PASSWORD parameter, 1-11

user authentication, 20-8

patch release number, 1-22

PCTFREE storage parameter

guidelines for setting, 10-3

block overhead and, 10-6

clustered tables, 10-4

default, 10-3

how it works, 10-2

indexes, 10-4

non-clustered tables, 10-4

PCTUSED and, 10-6

PCTINCREASE storage parameter

about, 10-8

altering, 10-11

setting for the data dictionary, 17-29

PCTUSED storage parameter

guidelines for setting, 10-5

block overhead and, 10-6

default, 10-5

how it works, 10-4

PCTFREE and, 10-6

performance

location of datafiles and, 9-4

tuning archiving, 23-9

performance tables

dynamic performance tables, 4-13

physical structure of a database, 1-19

PL/SQL program units

precedence of storage parameters, 10-11

replaced views and, 13-9

planning

database creation, 2-2

relational design, 1-19

the database, 1-19

predefined roles, 1-6

preface

Send Us Your Comments, iii

prerequisites

for creating a database, 2-3

PRIMARY KEY constraint

disabling, 17-20

dropping associated indexes, 14-10

enabling, 17-20

enabling on creation, 14-7

foreign key references when dropped, 17-21

indexes associated with, 14-7

storage of associated indexes, 14-7

private

rollback segments, 18-8

taking offline, 18-13

synonyms, 13-12

privileges, 21-2, 21-10

adding datafiles to a tablespace, 9-5

adding redo log groups, 5-5

altering

default storage parameters, 8-6

dispatcher privileges, 4-11

indexes, 14-9

named user limit, 20-6

passwords, 20-17

role authentication, 21-13

rollback segments, 18-10

sequences, 13-10

tables, 12-7

users, 20-16

analyzing objects, 17-3

application developers and, 19-9

audit object, 22-11

auditing system, 22-11

auditing use of, 22-9

bringing datafiles offline and online, 9-8

bringing tablespaces online, 8-8

cascading revokes, 21-21

cluster creation, 15-6

coalescing tablespaces, 8-7

column, 21-18

CREATE SCHEMA command, 17-2

creating

roles, 21-11

rollback segments, 18-8

database administrator, 1-4

disabling automatic archiving, 23-7

dropping

clusters, 15-10

indexes, 14-10

online redo log members, 5-9

redo log groups, 5-8

roles, 21-16

rollback segments, 18-14

dropping profiles, 20-22

enabling and disabling resource limits, 20-22

enabling and disabling triggers, 17-12

enabling automatic archiving, 23-6

for changing session limits, 20-5

forcing a checkpoint, 5-13

forcing a log switch, 5-13

granting

about, 21-16

object privileges, 21-17

required privileges, 21-17

system privileges, 21-16

grouping with roles, 21-11

individual privilege names, 21-2

job queues and, 7-4

listing grants, 21-28

manually archiving, 23-8

object, 21-9

on selected columns, 21-20

operating system

required for database administrator, 1-4

policies for managing, 19-5

recompiling packages, 17-27

recompiling procedures, 17-27

recompiling views, 17-27

renaming

datafiles of a tablespace, 9-9

datafiles of several tablespaces, 9-10

objects, 17-2

redo log members, 5-6

replacing views, 13-9

RESTRICTED SESSION system privilege, 3-4, 3-8

revoking, 21-19

ADMIN OPTION, 21-19

GRANT OPTION, 21-20

object privileges, 21-21

system privileges, 21-19

revoking object, 21-19

revoking object privileges, 21-19

setting resource costs, 20-21

SQL statements permitted by, 21-10

system, 21-2

taking tablespaces offline, 8-9

truncating, 17-11

procedures

SNP background processes, 7-2

processes, 4-1

PROCESSES parameter

disabling resource limits, 20-22

altering, 20-20

assigning to users, 20-19

composite limit, 20-20

creating, 20-19

default, 20-19

dropping, 20-22

enabling resource limits, 20-22

listing, 20-23

managing, 20-18

privileges for dropping, 20-22

privileges to alter, 20-20

privileges to set resource costs, 20-21

PUBLIC_DEFAULT, 20-19

setting a limit to null, 20-20

viewing, 20-26

program global area (PGA)

effect of MAX_ENABLED_ROLES on, 21-15

pseudo-column, 10-19

public

synonyms, 13-12

public rollback segments

making available for use, 18-11

taking offline, 18-13

PUBLIC user group

granting and revoking privileges to, 21-22

procedures and, 21-22

PUBLIC_DEFAULT profile

dropping profiles and, 20-22

using, 20-19

query server process

about, 4-17

quotas

listing, 20-23

revoking from users, 20-15

setting to zero, 20-15

tablespace, 20-14

tablespace quotas, 8-3

temporary segments and, 20-15

unlimited, 20-15

viewing, 20-25

read-only tablespaces

altering to writable, 8-13

creating, 8-11

datafiles, 9-7

on a WORM device, 8-13

REBUILD PARTITION clause

ALTER INDEX command, 11-5, 11-16

recompiling

recovery

creating new control files, 6-5

effects of archiving on, 23-2

startup with automatic, 3-5

redo log

archived redo log, 23-2

online redo log, 5-1

redo log files

archived redo log files, 23-4

log sequence numbers of

defined, 5-2

multi-plexing

overview of, 5-2

online, 5-2

viewing, 2-8

REFERENCES privilege

CASCADE CONSTRAINTS option, 21-20

dropping table partition with, 11-7

referential integrity constraints

truncating table partition with, 11-9

relational design

planning, 1-19

releases

checking the release number, 1-23

identifying for Oracle7 Server, 1-21

maintenance release number, 1-22

patch release number, 1-22

port-specific release number, 1-22

versions of other Oracle software, 1-23

relocating

control files, 6-4

datafiles, 9-8, 9-10

remote connections

connecting as INTERNAL, 1-14, 1-15, 1-16, 1-17, 1-19, 1-20, 1-21, 1-22, 1-23

connecting as SYSOPER/SYSDBA, 1-14

password files, 1-9

REMOTE_LOGIN_PASSWORDFILE parameter, 1-11

REMOTE_OS_AUTHENT parameter

setting, 20-10

REMOTE_OS_ROLES parameter

setting, 21-14, 21-26

RENAME command, 17-2

Rename Data File dialog, 9-9

Rename Online Redo Log Member dialog box, 5-7

renaming

control files, 6-4

datafiles, 9-8, 9-10

datafiles with a single table, 9-9

online redo log members, 5-6

schema objects, 17-2

replacing

views, 13-9

resource limits

altering in profiles, 20-20

assigning with profiles, 20-19

composite limits and, 20-20

costs and, 20-21

creating profiles and, 20-19

disabling, 20-22

enabling, 20-22

privileges to enable and disable, 20-22

privileges to set costs, 20-21

PUBLIC_DEFAULT profile and, 20-19

service units, 20-20

setting to null, 20-20

RESOURCE role, 21-12

RESOURCE_LIMIT parameter

enabling and disabling limits, 20-22

resources

of a database administrator, 1-2

responsibilities

of database users, 1-3

RESTRICTED SESSION privilege

instances in restricted mode, 3-7

restricted mode and, 3-4

session limits and, 20-3

restricting access to database

starting an instance, 3-4

REVOKE command, 21-19

when takes effect, 21-22

Revoke System Privileges/Roles dialog, 21-19

revoking

privileges and roles

SYSOPER/DBA privileges, 1-13

revoking privileges and roles

on selected columns, 21-20

REVOKE command, 21-19

shortcuts for object privileges, 21-10

when using operating-system roles, 21-25

roles

ADMIN OPTION and, 21-16

application developers and, 19-10

authorization, 21-13

backward compatibility, 21-12

changing authorization for, 21-15

changing passwords, 21-15

CONNECT role, 21-12

database authorization, 21-13

DBA role, 1-6, 21-12

default, 20-17

dropping, 21-15

EXP_FULL_DATABASE, 21-12

GRANT command, 21-26

GRANT OPTION and, 21-18

granting

about, 21-16

grouping with roles, 21-11

IMP_FULL_DATABASE, 21-12

listing, 21-30

listing grants, 21-28

listing privileges and roles in, 21-30

management using the operating system, 21-23

managing, 21-11

multi-byte characters

in names, 21-11

multi-byte characters in passwords, 21-13

multi-threaded server and, 21-14

operating system granting of, 21-24, 21-26

operating-system authorization, 21-14

OS management and the multi-threaded server, 21-26

passwords for enabling, 21-13

predefined, 1-6, 21-12

privileges

changing authorization method, 21-13

changing passwords, 21-13

for creating, 21-11

for dropping, 21-16

granting system privileges or roles, 21-16

RESOURCE role, 21-12

REVOKE command, 21-26

revoking, 21-19

revoking ADMIN OPTION, 21-19

security and, 19-6

SET ROLE command, 21-26

unique names for, 21-11

without authorization, 21-14

rollback segments

acquiring automatically, 18-3, 18-12

acquiring on startup, 2-12

allocating, 2-14

altering public, 18-10

altering storage parameters, 18-9

AVAILABLE, 18-11

bringing

online, 18-11

online automatically, 18-12

online when new, 18-8

PARTLY AVAILABLE segment online, 18-12

checking if offline, 18-13

choosing how many, 2-14

choosing size for, 2-14

creating, 18-8

creating after database creation, 18-3

creating public and private, 18-3

decreasing size of, 18-10

deferred, 18-17

displaying

all deferred rollback segments, 18-17

deferred rollback segments, 18-17

information on, 18-15

PENDING OFFLINE segments, 18-16

displaying names of all, 18-16

dropping, 18-14

equally sized extents, 18-5

explicitly assigning transactions to, 18-13

guidelines for managing, 18-2

initial, 18-2

invalid status, 18-15

listing extents in, 17-35

location of, 18-7

making available for use, 18-11

managing, 18-1

monitoring, 18-6, 18-15

OFFLINE, 18-11

offline rollback segments, 18-11

offline status, 18-12

online rollback segments, 18-11

online status, 18-12

PARTLY AVAILABLE, 18-11

PENDING OFFLINE, 18-13

privileges

for dropping, 18-14

required to alter, 18-10

required to create, 18-8

setting size of, 18-4

status for dropping, 18-14

status or state, 18-11

storage parameters, 18-9

storage parameters and, 18-8

SYSTEM rollback segment, 18-3

taking offline, 18-12

taking tablespaces offline and, 8-11

transactions and, 18-13

using multiple, 18-2

ROLLBACK_SEGMENTS parameter

adding rollback segments to, 18-8

chaining across blocks, 10-4, 17-9

ROWID datatype, 10-19

ROWID pseudo-column, 10-19

rows

violating integrity constraints, 17-16

schema objects

auditing, 22-9

creating multiple objects, 17-2

default audit options, 22-11

dependencies between, 17-25

disabling audit options, 22-13

enabling audit options on, 22-11

listing by type, 17-34

listing information, 17-32

privileges to access, 21-9

privileges to rename, 17-2

renaming, 17-2, 17-3

SCN, 9-13

security

segments

data and index

default storage parameters, 10-10

data dictionary, 17-29

displaying information on, 17-35

monitoring, 18-15

rollback, 18-1

temporary storage parameters, 10-12

Send Us Your Comments

boilerplate, iii

sensitivity

security, 19-3

SEQUENCE_CACHE_ENTRIES parameter, 13-11

sequences

altering, 13-11

creating, 13-10

dropping, 13-12

initialization parameters, 13-11

managing, 13-10

Parallel Server and, 13-11

privileges for altering, 13-10

privileges for creating, 13-10

privileges for dropping, 13-12

server units

composite limits and, 20-20

servers

dedicated

multi-threaded contrasted with, 4-3

multi-threaded

dedicated contrasted with, 4-3

service name

for dispatcher in multi-threaded server, 4-6

session limits, license

setting initially, 2-13

session monitor, 4-12

session, user

active, 4-21

inactive, 4-21

marked to be terminated, 4-21

terminating, 4-20

viewing terminated sessions, 4-21

sessions

auditing connections and disconnections, 22-8

limits per instance, 20-2

listing privilege domain of, 21-29

number of concurrent sessions, 2-13

Parallel Server session limits, 2-13

setting maximum for instance, 20-4

setting warning limit for instance, 20-4

viewing current number and high water mark, 20-7

viewing memory use, 20-27

SET ROLE command

how password is set, 21-13

when using operating-system roles, 21-26

Set Rollback Segment Offline dialog, 18-12

Set Rollback Segment Online dialog, 18-11

Set Rollback Segment Storage dialog, 18-8

Set Tablespace Online dialog, 8-8

Set Tablespace Storage dialog box, 8-6

SET TRANSACTION command

USE ROLLBACK SEGMENT option, 18-13

SGA

determing buffers in cache, 2-11

shared mode

rollback segments and, 18-3

shared pool

ANALYZE command and, 17-8

multi-threaded server and, 4-5

shared server processes

changing the minimum number of, 4-10

maximum number of, 4-9

number to start initially, 4-9

privileges to change number of, 4-10

trace files for, 4-14

shared SQL areas

ANALYZE command and, 17-8

shortcuts

CONNECT, for auditing, 22-8

object auditing, 22-10

object privileges, 21-10

statement level auditing options, 22-8

Shut Down menu, 3-8

Abort Instance option, 3-12

Immediate option, 3-11

Normal option, 3-10

SHUTDOWN command, 3-8

ABORT option, 3-12

IMMEDIATE option, 3-11

NORMAL option, 3-11

shutting down a database, 3-1

shutting down an instance

aborting the instance, 3-12

connecting and, 3-8

connecting as INTERNAL, 3-9

example of, 3-11

general procedures, 3-8

size

on non-clusterd tables, A-2

rollback segments, 18-4

snapshot logs

snapshots

OPTIMAL storage parameter and, 18-6

too old

SNP background processes

about, 7-2

software versions, 1-21

SORT_AREA_SIZE parameter

index creation and, 14-3

space

adding to the database, 8-4

used by indexes, 14-9

space management

PCTFREE, 10-2

PCTUSED, 10-4

SPLIT PARTITION clause, 11-11

ALTER INDEX command, 11-11

ALTER TABLE command, 11-5, 11-10

SQL statements

disabling audit options, 22-12

enabling audit options on, 22-10

privileges required for, 21-10

SQL trace facility

when to enable, 4-16

SQL*Loader

about, 1-17

indexes and, 14-3

SQL_TRACE parameter

trace files and, 4-14

STALE status

of redo log members, 5-9

Start Automatic Archiving dialog, 23-13

Start Up Instance dialog box, 3-2

Force check box, 3-5

Mount radio button, 3-4

Nomount radio button, 3-3

Open radio button, 3-4

Restrict to DBAs check box, 3-5

specifying a parameter file, 3-3

starting a database

about, 3-1

general procedures, 3-2

starting an instance

starting Server Manager, 2-6

specifying database name, 3-2

specifying parameter file, 3-3

statistics

updating, 17-4

Stop Auto Archive menu option, 23-7

storage

altering tablespaces, 8-6

quotas and, 20-14

revoking tablespaces and, 20-15

unlimited quotas, 20-15

storage parameters

stored procedures

privileges for recompiling, 17-27

using privileges granted to PUBLIC, 21-22

stream

tape drive, 23-10

synonyms

creating, 13-12

displaying dependencies of, 17-35

privileges for creating, 13-12

dropping, 13-13

managing, 13-12

private, 13-12

privileges for dropping, 13-13

public, 13-12

SYS

initial password, 1-5

objects owned, 1-5

policies for protecting, 19-7

privileges, 1-5

user, 1-5

SYS.AUD$

audit trail, 22-2

creating and deleting, 22-4

SYSOPER/SYSDBA privileges

adding users to the password file, 1-12

connecting with, 1-14

determining who has privileges, 1-13

granting and revoking, 1-13

SYSTEM

initial password, 1-5

objects owned, 1-5

policies for protecting, 19-7

user, 1-5

System Change Number (SCN)

checking for a datafile, 9-13

System Global Area, 2-11

System Global Area (SGA), 2-11

system privileges, 21-2

SYSTEM rollback segment

adding, 18-3

altering storage parameters of, 18-10

rollback segments, 18-3

SYSTEM tablespace

cannot drop, 8-14

initial rollback segment, 18-2

non-data dictionary tables and, 12-3

restrictions on taking offline, 9-7

when created, 8-3

table partition

containing global index, 11-6

merging adjacent, 11-13

splitting, 11-10

truncating, 11-8

tables

adding partitions, 11-5

allocating extents, 12-9

altering, 12-7, 12-8

analyzing statistics, 17-3

clustered tables

privileges to drop, 15-10

storage, A-16

creating, 12-7

designing before creating, 12-2

dropping, 12-9

estimating initial size, A-2

estimating size, 12-5, A-5

guidelines for managing, 12-1, 12-6

hash clustered

creating, 16-5

managing, 16-1

increasing column length, 12-8

indexes and, 14-2

key-preserved, 13-5

limiting indexes on, 14-3

location, 12-7

location of, 12-3

managing, 12-1

parallelizing creation of, 12-4

privileges for creation, 12-6

privileges for dropping, 12-9

privileges to alter, 12-7

schema of clustered, 15-7

separating from indexes, 12-6

specifying PCTFREE for, 10-4

specifying tablespace, 12-3, 12-7

SYSTEM tablespace and, 12-3

temporary space and, 12-6

transaction parameters, 12-3

truncating, 17-10

UNRECOVERABLE, 12-4

validating structure, 17-9

tablespaces

adding datafiles, 9-5

altering availability, 8-8

altering storage settings, 8-6

assigning defaults for users, 20-13

assigning user quotas, 8-3

bringing online, 8-8

checking default storage parameters, 8-16

coalescing, 8-6

creating, 8-3

creating additional, 8-4

default quota, 20-14

default storage parameters for, 10-10

default temporary, 20-14

dropping

about, 8-14

required privileges, 8-14

guidelines for managing, 8-2

listing files of, 8-16

listing free space in, 8-17

location, 9-4

managing, 9-1

monitoring, 9-13

privileges for creating, 8-4

privileges to take offline, 8-9

quotas

assigning, 8-3

quotas for users, 20-14

read-only, 8-11

revoking from users, 20-15

rollback segments required, 8-5

setting default storage parameters for, 8-3

SYSTEM tablespace, 8-3

taking offline normal, 8-9

taking offline temporarily, 8-9

temporary, 20-14

unlimited quotas, 20-15

using multiple, 8-2

viewing quotas, 20-25

writable, 8-13

taking offline

tablespaces, 8-9

tape drives

streaming for archiving, 23-10

temporary segments

index creation and, 14-3

temporary space

allocating, 12-6

terminating

a user session, 4-20

terminating sessions

active sessions, 4-21

identifying sessions, 4-20

inactive session, example, 4-21

inactive sessions, 4-21

test

security for databases, 19-9

time window

moving, in historical table, 11-16

tip

object privilege shortcut, 21-10

shortcuts for auditing objects, 22-10

statement auditing shortcut, 22-8

trace files

job failures and, 7-11

transaction entries

guidelines for storage, 10-9

transactions

assigning to specific rollback segment, 18-13

rollback segments and, 18-13

TRANSACTIONS parameter

using, 18-2

TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter

using, 18-2

triggers

auditing, 22-21

disabling, 17-13

privileges for controlling, 21-10

enabling, 17-13

examples, 22-21

privileges for enabling and disabling, 17-12

TRUNCATE command, 17-10

DROP STORAGE option, 17-11

REUSE STORAGE option, 17-11

TRUNCATE PARTITION clause

ALTER TABLE command, 11-8

truncating

clusters, 17-10

partitioned objects, 11-8

privileges for, 17-11

tables, 17-10

Trusted Oracle7 Server

controlling database access, 20-1

managing tablespaces and datafiles, 9-2

managing users and resources, 20-1

tuning

archiving, 23-9

databases, 1-21

initially, 2-14

UNIQUE key constraints

disabling, 17-20

dropping associated indexes, 14-10

enabling, 17-20

enabling on creation, 14-7

foreign key references when dropped, 17-21

indexes associated with, 14-7

storage of associated indexes, 14-7

UNLIMITED TABLESPACE privilege, 20-15

unrecoverable

tables, 12-4

unrecoverable indexes

indexes, 14-5

UPDATE privilege

USER_DUMP_DEST parameter, 4-15

Use, 20-11

USER_EXTENTS, 9-13

USER_FREE, 8-15, 9-13

USER_INDEXES view

USER_SEGMENTS, 8-15, 9-13

USER_TAB_COLUMNS view

USER_TABLES view

USER_TABLESPACES, 8-15, 9-13

usernames

SYS and SYSTEM, 1-5

users

altering, 20-16

assigning profiles to, 20-19

assigning tablespace quotas, 8-3

assigning unlimited quotas for, 20-15

auhentication

database authentication, 20-8

authentication

about, 19-2, 20-7

changing authentication method, 20-17

changing default roles, 20-17

changing passwords, 20-17

composite limits and, 20-20

default tablespaces, 20-13

dropping, 20-17

dropping profiles and, 20-22

dropping roles and, 21-15

end-user security policies, 19-5

enrolling, 1-21

identification, 20-8

in a newly created database, 2-14

limiting number of, 2-13

listing, 20-23

listing privileges granted to, 21-28

listing roles granted to, 21-28

managing, 20-12

multi-byte characters

in names, 20-13

in passwords, 20-13

objects after dropping, 20-17

password security, 19-4

policies for managing privileges, 19-5

privileges for changing passwords, 20-16

privileges for creating, 20-12

privileges for dropping, 20-18

PUBLIC group, 21-22

security and, 19-2

security for general users, 19-4

session, terminating, 4-21

specifying user names, 20-12

tablespace quotas, 20-14

unique user names, 2-13, 20-6

viewing information on, 20-25

viewing memory use, 20-27

viewing tablespace quotas, 20-25

utilities

Export, 1-17

for the database administrator, 1-17

Import, 1-17

SQL*Loader, 1-17

UTLCHAIN.SQL, 17-9

UTLLOCKT.SQL script, 4-12

V$ARCHIVE view, 23-10

V$DATABASE view, 23-10

V$DATAFILE, 8-15, 9-13

V$DBFILE view, 2-8

V$DISPATCHER view

controlling dispatcher process load, 4-10

V$LICENSE view, 20-7

V$LOG view

displaying archiving status, 23-10

online redo log and, 5-15

V$LOGFILE view, 2-8

V$PWFILE_USERS view, 1-13

V$QUEUE view

controlling dispatcher process load, 4-10

V$ROLLNAME

finding PENDING OFFLINE segments, 18-16

V$ROLLSTAT

finding PENDING OFFLINE segments, 18-16

V$SESSION, 7-16

V$SESSION view, 4-21

V$THREAD view, 5-15

VALIDATE STRUCTURE option, 17-9

VARCHAR2 datatype, 10-17

space use of, 10-17

versions, 1-21

of other Oracle software, 1-23

view

partitioned

converting to partitioned table, 11-14

views

creating, 13-2

creating with errors, 13-4

displaying dependencies of, 17-35

FOR UPDATE clause and, 13-3

dropping, 13-10

managing, 13-1, 13-10

ORDER BY clause and, 13-3

privileges, 13-2

privileges for dropping, 13-10

privileges for recompiling, 17-27

privileges to replace, 13-9