Oracle8i Generic Documentation Master Index

ub1

definition, OCI 3-27

ub2

definition, OCI 3-27

ub4

definition, OCI 3-27

UID function, PCO 4-7, SQL 4-51

unary operator, PLS 2-41

unary operators, SQL 3-1

unavailable option (RMAN)

change command, SBR 6-8

unbound tx wait event, SRF A-48

underscore, PLS 2-4

alternate mappings, NLS 4-9

undo, SCN 1-11

See also rollback

undo a transaction, PC_ F-99, PCO F-74

undo block statistic, STU 21-3

undo segment extension wait event, SRF A-48

undo segment recovery wait event, SRF A-49

undo segment tx slot wait event, SRF A-49

undo segment, serialization enqueue, SRF B-2

unhandled exception, PLS 6-12, PLS 6-19

unhandled exceptions, ADG 10 - 46

UNI_PLUGGABLE_SET_CHECK view, SRF 2-187

UNICODE, NLS 3-24

Unicode

and UTF-8, OCI 5-29

character set Id, OCI A-20, OCI A-22

fixed width support, OCI 5-28

OCILobRead(), OCI 15-151

OCILobWrite(), OCI 15-156

precautions, OCI 5-29

Unicode character set, PC_ 5-9

Unicode variables, PC_ A-4

uninitialized object

how treated, PLS 9-24

UNION ALL operator, SQL 3-12

examples, SCN 23-11, SCN 23-13, SCN 23-27

optimizing view queries, SCN 23-16

transforming OR into, SCN 23-10

UNION ALL set operator, PLS 5-6, SQL 7-550

UNION ALL view, STU 8-7

UNION ALL views, SCN 11-11

UNION operator, SQL 3-12

compound queries, SCN 23-4

examples, SCN 23-18, SCN 23-28

optimizing view queries, SCN 23-16

UNION set operator, PLS 5-6, SQL 7-550

unions

cannot be nested in host structures, PC_ 4-41

not permitted as host structures, PC_ 4-41

UNIQUE clause

of constraint_clause, SQL 7-221

of CREATE INDEX, SQL 7-278

of CREATE TABLE, SQL 7-369

of SELECT, SQL 7-545

UNIQUE constraint, STU 6-10, STU 27-21

simple subquery snapshots and, REP 3-13

unique constraints

enabling, SQL 7-382

index on, SQL 7-382

UNIQUE index, STU 6-16

unique indexes, SCN 10-22, SQL 7-278

Import, SUT 2-25

unique key, DDS 4-3

UNIQUE key constraints, SCN 28-8

unique keys, SCN 1-58, SCN 1-59, SCN 28-9

composite, SCN 28-9, SCN 28-11

optimization, SCN 23-14

searches, SCN 23-40

unique queries, SQL 7-545

unique values

generating with SQL*Loader, SUT 5-56

uniqueness, STU 6-10

uniqueness conflicts, REP 6-3

avoiding, REP 6-5

resolution, REP 6-8

configuring, REP 6-34

resolution methods, REP 6-9

assigning, REP 6-34

removing, REP 6-35

resolving, REP 6-50

uniqueness constraints

Import, SUT 2-48

preventing errors during import, SUT 2-20

Universal Installer, GTK 2-59, GTK 2-63

Universal ROWID, OCI 3-6, PC_ A-5

universal ROWID, PCO A-3

ROWID pseudocolumns, PCO 4-37

universal rowid, PLS 2-16

universal ROWIDs (UROWIDs), GTK 2-30

Universal ROWIDs. See UROWIDs

universal rowids. See urowids

universal rowids. See urowids.

UNIX

disadvantages of signal handlers, NET 9-14

finding bootstrap, LEG 5-6, LEG 5-12, LEG 5-21

linking a Pro*C application under, PC_ 1-10

Oracle's operating system dependent call for signal handling, NET 9-14

recovering OS and NetWorker, LEG 5-10, LEG 5-19

recovering server indexes and configuration files, LEG 5-11

recovering to new server, LEG 5-16, LEG 5-25

renaming configuration files, LEG 5-15

using both signal handling and Net8, NET 9-14

using signal handlers with, NET 9-13

UNIX system performance, STU 24-4

unlabeled volumes, LEG 3-19

UNLIMITED extents, SCN 26-40

unlimited extents, STU 20-28

UNLIMITED TABLESPACE privilege, SAD 23-14

UNLIMITED TABLESPACE system privilege, SQL 7-500

UNLOAD (DB2 file format)

not supported by SQL*Loader, SUT B-4

unmarking, OCI 13-10

objects, OCI 13-10

Unnecessary process cleanup for SCN batching statistic, SRF C-5

unnesting collections, SQL 7-547

examples, SQL 7-564

unnesting queries, ADG 18 - 13

unpinning, OCI 10-28, OCI 13-8

objects, OCI 13-8

UNRECOVERABLE, SQL 7-36, SQL 7-371

See also NOLOGGING clause.

unrecoverable

tables, SAD 14-4

UNRECOVERABLE DATAFILE option

ALTER DATABASE command, SAD 6-17

unrecoverable indexes

indexes, SAD 16-5

UNRECOVERABLE keyword

SQL*Loader, SUT 8-19

unrecoverable objects

and RECOVER operation, SBR 14-5

UNRECOVERABLE operations

backups after, SBR 16-28

performing backups after, SBR 3-19

UNREGISTER command, NET A-87

UNREGISTER_SNAPSHOT procedure

DBMS_SNAPSHOT package, REP 7-37

unregistering a database from the recovery catalog, SBR 6-6

UNSAFE_NULL precompiler option, PC_ 10-41, PCO 14-40

UNSCHEDULE_PUSH procedure

DBMS_DEFER_SYS package, REP 2-16

UNSIGNED

external datatype, OCI 3-15

UNSIGNED datatype, PC_ 4-10, PCO 4-14

unsorted data

direct path load

SQL*Loader, SUT 8-17

unsorted indexes, SQL 7-282

until clause (RMAN), SBR 11-42, SBR 11-146

UNTIL TIME option

RECOVER command, SBR 14-31

unusable, STU 32-4

UNUSABLE clause

of ALTER INDEX, SQL 7-39

UNUSABLE indexes

function-based, SCN 21-8

UNUSABLE LOCAL INDEXES clause

of ALTER MATERIALIZED VIEW, SQL 7-49

of ALTER TABLE, SQL 7-146

UNUSED column, SCN 10-6

unused columns

dropping, MIG 12-8

UPDATE

object privilege, SQL 7-508

statement, SQL 7-584

UPDATE ANY TABLE system privilege, SQL 7-500

UPDATE CASCADE, PC_ 9-21

UPDATE command, SCN 16-4

column values and triggers, ADG 13 - 16

data consistency, ADG 8 - 11

foreign key references and, SCN 28-16

freeing space in data blocks, SCN 4-9

no-logging mode, SCN 25-7

LOBs, SCN 25-7

parallel UPDATE, SCN 26-21

triggers and, ADG 13 - 6, ADG 13 - 18, SCN 20-2, SCN 20-6

BEFORE triggers, SCN 20-9

triggers for referential integrity, ADG 13 - 43, ADG 13 - 44

update conflicts, REP 6-3

avoiding, REP 6-5

resolution

and column groups, REP 6-7

using site priority for, REP 6-29

resolution methods

assigning, REP 6-17

prebuilt, REP 6-8

resolution of

minimizing data propagation for, REP 6-42

resolving, REP 6-49

update frequency, STU 32-2

update no action constraint, SCN 28-16

UPDATE privilege

revoking, SAD 24-13

UPDATE privilege for object tables, SCN 14-15, SCN 14-16

UPDATE SQL statement, PC_ F-112

UPDATE statement, PCO F-85

embedded SQL examples, PC_ F-116, PCO F-89

example, PCO 5-10

example of, PC_ 6-9

purpose of, PC_ 6-9

RETURNING clause, PLS 5-63

SET clause, PCO 5-10

SET clause in, PC_ 6-10

syntax, PLS 11-159

triggers on, SQL 7-404

using host arrays in, PC_ 8-12

using host tables, PCO 7-13

WHERE clause in, PC_ 6-10

update window, STU 32-2

UPDATE_BY_CAT

procedure of OUTLN_PKG, STU 7-30, STU 7-31

updatable snapshot, REP 1-8, SCN 34-9

updated locators, ADL 2-2, ADL 2-5, ADL 2-10, ADL 2-12, ADL 2-19

updates, OCI 2-34

updating

Comments, REP 7-38

replication tables, REP 7-38

rows in tables and views, PC_ F-112, PCO F-85

updating records in recovery catalog, SBR 6-13

updating rows in a table

SQL*Loader, SUT 5-33

updating tables

with parent keys, ADG 5 - 10, ADG 5 - 11

upgrade

Oracle, SPS 23-1

replicated systems, SPS 23-1

upgrade catalog command (RMAN), SBR 11-148

upgrades, NET 5-1 to NET 5-30

defined, NET 5-16

LISTENER.ORA changes, NET 5-20

modifying configuration files, NET 5-19

NAMESINI.SQL script for Oracle Names, NET 5-24

of software, NET 5-18

of TNSNAMES.ORA with Net8 Assistant, NET 5-11

Oracle Connection Manager, NET 5-21

SQLNET.ORA changes, NET 5-19

TNSNAMES.ORA changes, NET 5-19

verify service name and instance name, NET 5-17

upgrading

7.x to 8.0, OCI 1-22

7.x to 8.0 OCI, OCI 1-23

Advanced Queuing, MIG 7-26

Advanced Replication, MIG 7-21

applications, MIG 9-1

definition, MIG 1-3

drop Java objects, MIG 7-36

export Java objects, MIG 7-3

import Java objects, MIG 7-36

initialization parameters, MIG 7-15

manually, MIG 7-13

Oracle Forms applications, MIG 9-6

Oracle Parallel Server, MIG 7-1, MIG 7-24

rolling upgrade, MIG 1-5

OUTLN user, avoid, MIG 7-4

parallel execution, MIG 7-34

paths, MIG 7-2

post-upgrading actions, MIG 7-33

precompiler applications, MIG 9-4

queue tables, MIG 7-29

recovery catalog, MIG 7-30

scripts, MIG 7-18

CATALOG.SQL, MIG 7-19

CATPARR.SQL, MIG 7-24

CATPROC.SQL, MIG 7-19

CATREP.SQL, MIG 7-21

errors while running, MIG 1-3

rerunning, MIG 7-19

UTLCONST.SQL script, MIG 7-33

UTLRP.SQL, MIG 7-32

snapshots, MIG 7-25

specific components, MIG 7-21

SQL*Plus scripts, MIG 9-6

steps, MIG 7-3

supported releases, MIG 7-2

to the cost-based optimizer, STU 7-34

user-defined datatypes, MIG 7-30

using the Oracle Data Migration Assistant, MIG 7-7

upgrading the recovery catalog, SBR 6-34

upgrading, Oracle Parallel Server issues, PSC 3-8

UPPER function, ADG 6 - 8, SQL 4-51

uppercase characters, SRF 1-3

URL (uniform resource locator), PLS 8-17

UROWID

Universal ROWID, OCI 3-6

UROWID datatype, GTK 2-30, PLS 2-16, SCN 12-15, SQL 2-23

UROWIDs

compatibility, MIG 8-11

downgrading, MIG 12-17

interoperability, MIG 8-26

urowids

and foreign tables, SQL 2-23

and heap-organized tables, SQL 2-23

and index-organized tables, SQL 2-23

description of, SQL 2-23

Use, NET 7-68, SAD 10-10, SAD 23-10

use

thread context, PC_ 11-9, PC_ F-33

Use Dedicated Server option, NET 7-7

Use each address in order until destination reached option, NET 5-14

Use for Heterogeneous Service option

Net8 Assistant

Use for Heterogeneous Service option, NET 7-68

Use for Heterogeneous Services option, NET 7-7

Use Options Compatible with Net8 8.0 Clients option, NET 5-11

Use Oracle8i Release 8.0 Compatible Identification option, NET 5-11

USE ROLLBACK SEGMENT clause

of SET TRANSACTION, SQL 7-573

USE_ASYNC_CALL parameter, NET C-79

USE_CMAN parameter, NET 7-26, NET 7-33, NET 7-36, NET 7-40, NET 7-42, NET C-30

USE_CONCAT hint, SQL 2-59, STU 7-50

USE_DEDICATED_SERVER parameter, NET 7-26, NET C-30

USE_HASH hint, SQL 2-61

USE_INDIRECT_DATA_BUFFERS parameter, SCN 7-14, SRF 1-126

USE_ISM parameter, SRF 1-126

USE_MERGE hint, SQL 2-61, STU 7-54

USE_NL hint, SQL 2-61, STU 7-53

USE_PLUG_AND_PLAY parameter, NET 5-24, NET 6-40, NET C-64

USE_PLUGANDPLAY parameter, NET A-23

USE_STORED_OUTLINES parameter, STU 7-28

of ALTER SESSION, SQL 7-89

of ALTER SYSTEM, SQL 7-108

USE_STORED_OUTLINES session parameter, GTK 2-37, SCN 22-6

USER

data dictionary view, DDS 2-20

user

benefits of parallel database, SPS 1-14

handles, STU 25-23

memory allocation, STU 19-7

multiple, SPS 5-4

name and password, SPS 18-20

PUBLIC, SPS 14-6, SPS 14-7

SYS, SPS 14-7

user account, OAS 7-14

user calls statistic, SRF C-20

user commits statistic, SRF C-21

user configuration file

to set precompiler options, PC_ 10-3

user defined object identifiers, GTK 2-34

user definitions

importing, SUT 2-14

user errors

database failures, SBR 1-12

definition, SBR 1-12

recovery from, SBR 15-14

user exit

calling from a SQL*Forms trigger, PCO 12-7

common uses, PCO 12-4

defined, PCO 12-3

guidelines, PCO 12-13

linking into IAP, PCO 12-12

meaning of codes returned by, PCO 12-8

naming, PCO 12-13

passing parameters, PCO 12-8

requirements for variables, PCO 12-5

return codes, PCO 12-8

running the GENXTB form, PCO 12-12

statements allowed in, PCO 12-5

steps in developing, PCO 12-4

using EXEC IAF statements, PCO 12-5

using EXEC TOOLS statements, PCO 12-14

using the WHENEVER statement, PCO 12-9

User Exits, PC_ E-3

user exits

calling from a SQL*Forms trigger, PC_ 20-6

common uses for, PC_ 20-3

example of, PC_ 20-9

guidelines for, PC_ 20-13

kinds of statements allowed in, PC_ 20-4

linking into IAP, PC_ 20-13

meaning of codes returned by, PC_ 20-8

naming, PC_ 20-13

passing parameters to, PC_ 20-7

requirements for variables in, PC_ 20-4

running the GENXTB form, PC_ 20-12

running the GENXTB utility for, PC_ 20-13

steps in developing, PC_ 20-3

use of IAF GET statements in, PC_ 20-5

use of IAF PUT statements in, PC_ 20-6

use of WHENEVER statement in, PC_ 20-9

USER function, ADG 5 - 4, PCO 4-8, SQL 4-52

user locks, SCN 27-39

requesting, ADG 8 - 21

User Manager, for Oracle Enterprise Manager, PSC 5-22

user memory

allocating, OCI 2-17

user name enqueue, SRF B-2

user process

free list, SPS 11-2, SPS 11-15, SPS 17-8

instance shutdown errors, SPS 18-26

manual archiving, SPS 21-4

user processes

allocate PGAs, SCN 7-14

connections and, SCN 8-4

dedicated server processes and, SCN 8-22

manual archiving by, SCN 32-21

sessions and, SCN 8-4

shared server processes and, SCN 8-19

trace files, SRF 1-126

user program interface (UPI), SCN 8-25

USER pseudocolumn, SCN 30-7

user resources

limiting, STU 26-10

user rollbacks statistic, SRF C-21

user session, PCO 3-18, PLS 5-40

definition of, PC_ 3-15

user session handle

attributes, OCI A-12

description, OCI 2-9

setting in service context, OCI 2-10

user tags, SBR 4-46

user trace files, PSC C-12

USER_ views, SCN 2-6

USER_ALL_TABLES view, SRF 2-188

USER_ARGUMENTS view, SRF 2-190

USER_ASSOCIATIONS view, SRF 2-191

USER_AUDIT_OBJECT view, SRF 2-191

USER_AUDIT_SESSION view, SRF 2-192

USER_AUDIT_STATEMENT view, SRF 2-193

USER_AUDIT_TRAIL view, SRF 2-194

USER_CATALOG view, SRF 2-196

CAT synonym, SRF 2-68

USER_CLU_COLUMNS view, SRF 2-198

USER_CLUSTER_HASH_EXPRESSIONS view, SRF 2-197

USER_CLUSTERS view, SRF 2-196

CLU synonym, SRF 2-68

USER_COL_COMMENTS view, SQL 7-212, SRF 2-198

USER_COL_PRIVS view, SRF 2-198

USER_COL_PRIVS_MADE view, SRF 2-199

USER_COL_PRIVS_RECD view, SRF 2-199

USER_COLL_TYPES view, SRF 2-199

USER_CONS_COLUMNS view, SRF 2-201

USER_CONSTRAINTS view, SRF 2-200

USER_DB_LINKS view, SRF 2-202

USER_DEPENDENCIES view, SRF 2-202

USER_DIM_ATTRIBUTES view, SRF 2-203

USER_DIM_CHILD_OF view, SRF 2-203

USER_DIM_HIERARCHIES view, SRF 2-204

USER_DIM_JOIN_KEY view, SRF 2-204

USER_DIM_LEVEL_KEY view, SRF 2-205

USER_DIM_LEVELS view, SRF 2-204

USER_DIMENSIONS view, SRF 2-202

USER_DUMP_DEST, STU 14-4

SQL Trace parameter, STU 14-4

USER_DUMP_DEST parameter, PSC C-12, SAD 4-11, SRF 1-126

of ALTER SYSTEM, SQL 7-109

USER_ERRORS view, SRF 2-205

debugging stored procedures, ADG 10 - 43

USER_EXTENTS, SAD 10-13

USER_EXTENTS view, SRF 2-205

USER_FREE, SAD 9-31, SAD 10-13

USER_FREE_SPACE view, SRF 2-206

USER_HISTOGRAMS view, STU 7-6

USER_ID column

TKPROF_TABLE, STU 14-19

USER_IND_COLUMNS view, SRF 2-209

USER_IND_PARTITIONS view, SRF 2-210

USER_IND_SUBPARTITIONS view, SRF 2-211

USER_INDEXES view, SRF 2-206, STU 6-16

filling with data, SAD 20-5

IND synonym, SRF 2-172

USER_INDEXTYPE_OPERATORS view, SRF 2-213

USER_INDEXTYPES view, SRF 2-212

USER_JOBS view, SRF 2-213

USER_LIBRARIES view, SRF 2-214

USER_LOB_PARTITIONS view, SRF 2-215

USER_LOB_SUBPARTITIONS view, SRF 2-216

USER_LOBS view, SRF 2-214

USER_METHOD_PARAMS view, SRF 2-217

USER_METHOD_RESULTS view, SRF 2-217

USER_MVIEW_AGGREGATES view, SRF 2-218

USER_MVIEW_ANALYSIS view, SRF 2-218

USER_MVIEW_DETAIL_RELATIONS view, SRF 2-219

USER_MVIEW_JOINS view, SRF 2-220

USER_MVIEW_KEYS view, SRF 2-220

USER_NESTED_TABLES view, SRF 2-221

USER_OBJ_AUDIT_OPTS view, SRF 2-224

USER_OBJECT_SIZE view, SRF 2-224

USER_OBJECT_TABLES view, SRF 2-221

USER_OBJECTS view, SRF 2-223

OBJ synonym, SRF 2-174

USER_OPANCILLARY view, SRF 2-225

USER_OPARGUMENTS view, SRF 2-225

USER_OPBINDINGS view, SRF 2-225

USER_OPERATORS view, SRF 2-226

USER_OULTINE_HINTS

view for stored outline hints, STU 7-29

USER_OUTLINE_HINTS view, SRF 2-226

USER_OUTLINES

view for stored outlines, STU 7-29

USER_OUTLINES view, SRF 2-227

USER_PART_COL_STATISTICS view, SRF 2-227

USER_PART_HISTOGRAMS view, SRF 2-228

USER_PART_INDEXES view, SRF 2-228

USER_PART_KEY_COLUMNS view, SRF 2-228

USER_PART_LOBS view, SRF 2-230

USER_PART_TABLES view, SRF 2-231

USER_PARTIAL_DROP_TABS view, SRF 2-232

USER_PASSWORD_LIMITS view, SRF 2-232

USER_POLICIES view, SRF 2-232

USER_QUEUE_SCHEDULES view, SRF 2-233

USER_QUEUE_TABLES view, SRF 2-234

USER_QUEUES view, SRF 2-235

USER_REFRESH view, REP 7-35, SRF 2-236

USER_REFRESH_CHILDREN view, REP 7-35, SRF 2-236

USER_REFS view, SRF 2-237

USER_REGISTERED_SNAPSHOTS view, SRF 2-238

USER_REPCATLOG view, SRF 2-238

USER_REPCOLUMN view, SRF 2-238

USER_REPCOLUMN_GROUP view, SRF 2-239

USER_REPCONFLICT view, SRF 2-239

USER_REPDDL view, SRF 2-239

USER_REPGENERATED view, SRF 2-239

USER_REPGENOBJECTS view, SRF 2-239

USER_REPGROUP view, SRF 2-239

USER_REPGROUPED_COLUMNS view, SRF 2-239

USER_REPKEY_COLUMNS view, SRF 2-239

USER_REPOBJECT view, SRF 2-240

USER_REPPARAMETER_COLUMN view, SRF 2-240

USER_REPPRIORITY view, SRF 2-240

USER_REPPRIORITY_GROUP view, SRF 2-240

USER_REPPROP view, SRF 2-240

USER_REPRESOL_STATS_CONTROL view, SRF 2-240

USER_REPRESOLUTION view, SRF 2-240

USER_REPRESOLUTION_METHOD view, SRF 2-240

USER_REPRESOLUTION_STATISTICS view, SRF 2-241

USER_REPSITES view, SRF 2-241

USER_RESOURCE_LIMITS view, SRF 2-241

USER_ROLE_PRIVS view, SRF 2-241

USER_RSRC_CONSUMER_GROUP_PRIVS view, SRF 2-241

USER_RSRC_MANAGER_SYSTEM_PRIVS view, SRF 2-242

USER_RULESETS view, SRF 2-242

USER_SEGMENTS, SAD 9-31, SAD 10-13

USER_SEGMENTS view, SRF 2-242

Export and, SUT 1-9

USER_SEQUENCES view, SRF 2-243

SEQ synonym, SRF 2-182

USER_SNAPSHOT_LOGS view, SRF 2-245

USER_SNAPSHOT_REFRESH_TIMES view, SRF 2-245

USER_SNAPSHOTS view, SRF 2-243

USER_SOURCE view, ADG 10 - 43, SRF 2-245

USER_SUBPART_COL_STATISTICS view, SRF 2-246

USER_SUBPART_HISTOGRAMS view, SRF 2-246

USER_SUBPART_KEY_COLUMNS view, SRF 2-247

USER_SYNONYMS view, SRF 2-247

SYN synonym, SRF 2-183

USER_SYS_PRIVS view, SRF 2-248

USER_TAB_COL_STATISTICS view, SCN 23-52, SRF 2-248

USER_TAB_COLUMNS

COLS synonym, SRF 2-69

USER_TAB_COLUMNS view, SCN 23-52, SRF 2-249, STU 7-5, STU 7-6

filling with data, SAD 20-5

USER_TAB_COMMENTS view, SQL 7-212, SRF 2-250

USER_TAB_HISTOGRAMS view, SRF 2-250

USER_TAB_PARTITIONS view, SRF 2-250

USER_TAB_PRIVS view, SRF 2-252

USER_TAB_PRIVS_MADE view, SRF 2-252

USER_TAB_PRIVS_RECD view, SRF 2-253

USER_TAB_SUBPARTITIONS view, SRF 2-253

USER_TABLES table, SPS 16-7

USER_TABLES view, SCN 23-52, SRF 2-254

filling with data, SAD 20-5

USER_TABLESPACES, SAD 9-31, SAD 10-13

USER_TABLESPACES view, SRF 2-256

USER_TRIGGER_COLS view, SRF 2-257

USER_TRIGGERS view, SRF 2-257

USER_TS_QUOTAS view, SRF 2-258

USER_TYPE_ATTRS view, SRF 2-259

USER_TYPE_METHODS view, SRF 2-259

USER_TYPES view, SRF 2-258

USER_UPDATABLE_COLUMNS view, SCN 10-15, SRF 2-260

USER_USERS view, SRF 2-260

USER_USTATS view, SRF 2-261

USER_VARRAYS view, SRF 2-261

USER_VIEWS view, SRF 2-262

user-created backup files

cataloging, SBR 6-28

user-created objects

in SYS schema, MIG 8-24

user-defined

notification methods, REP 6-52

user-defined callback functions, OCI 9-11

registering, OCI 9-11

user-defined conflict resolution method, REP 6-48

user-defined costs, SCN 22-17

user-defined datatypes, SCN 13-1, SCN 13-3, SCN 14-1

collections, SCN 13-10

nested tables, SCN 13-12

variable arrays (VARRAYs), SCN 13-11

downgrading, MIG 12-21

Export and Import, SCN 14-20

incomplete types, SCN 14-16

interoperability, MIG 8-29

new format, MIG 8-29

object types, SCN 13-2, SCN 13-4

use of table aliases, SCN 14-8

object-relational model, SCN 1-22

privileges, SCN 14-13

storage, SCN 14-18

upgrading, MIG 7-30

user-defined datatypes, See object-relational model

user-defined errors, ADG 10 - 44, ADG 10 - 45

user-defined exception, PLS 6-7

user-defined exceptions

PL/SQL, DDS 4-11

user-defined functions, SQL 4-56

expressions, SQL 5-5

name precedence of, SQL 4-57

naming conventions, SQL 4-58

restrictions on, SQL 7-268

user-defined locks enqueue, SRF B-2

user-defined object identifiers

compatibility, MIG 8-12

downgrading, MIG 12-22

user-defined object types

defining, SQL 7-414

user-defined operator, SCN 10-44

user-defined operators, GTK 2-31, SQL 3-16

user-defined record, PC_ 7-5, PCO 6-6, PLS 4-37

declaring, PLS 4-39

referencing, PLS 4-40

user-defined statistics

dropping, SQL 7-452, SQL 7-454, SQL 7-456, SQL 7-466, SQL 7-475, SQL 7-480

user-defined stored function

used in WHERE clause, PC_ 6-10

user-defined subtype, PLS 2-24

user-defined type equivalencing, PC_ F-111

user-defined types

categories of, SQL 2-25

USERENV function, SQL 4-52

USERID

Export parameter, SUT 1-26

Import parameter, SUT 2-32

SQL*Loader command-line parameter, SUT 6-9

USERID option

using with the SQLCHECK option, PCO E-4

when required, PC_ 10-42

USERID OTT parameter, OCI 14-24, PC_ 19-27

USERID precompiler option, PC_ 10-42, PCO 14-41

using with the SQLCHECK option, PC_ D-4

user-initiated disconnect, NET 2-3

user-level IDLM, SPS 8-10

USERLOCK.SQL script, SRF 5-4

user-mode Export

specifying, SUT 1-21

user-mode IPCs

and Cache Fusion, SPS 20-6

usernames

as reported in a trigger, ADG 13 - 25

defining, PC_ 3-2, PCO 3-3

hardcoding, PCO 3-3

schemas and, ADG 12 - 9

SYS and SYSTEM, SAD 1-5

users, SCN 29-2

access rights, SCN 29-2

allocating space for, SQL 7-427

altering, SAD 23-15

assigning default roles, SQL 7-181

assigning profiles to, SAD 23-18, SQL 7-427

assigning roles to, SQL 7-427

assigning tablespace quotas, SAD 9-3

assigning unlimited quotas for, SAD 23-14

associated with schemas, SCN 10-2

auditing, SCN 31-12

auhentication

database authentication, SAD 23-8

authenticating, SRF 1-92

authenticating to a remote server, SQL 7-257

authentication

about, SAD 22-2, SAD 23-7

authentication of, SCN 29-3

changing default roles, SAD 23-16

changing global authentication, SQL 7-181

composite limits and, SAD 23-19

coordinating concurrent actions of, SCN 1-30

creating, SQL 7-425

current user, SCN 18-10

dedicated servers and, SCN 8-22

default tablespaces, SAD 23-12

default tablespaces of, SCN 29-13, SQL 7-427

denying access to tables and views, SQL 7-520

distributed databases, SCN 33-17

dropped roles and, ADG 12 - 16

dropping, SAD 23-16

dropping profiles and, SAD 23-21

dropping roles and, SAD 24-8

enabling roles for, ADG 12 - 4

end-user security policies, SAD 22-5

enrolling, SAD 1-20

external, SQL 7-344, SQL 7-426

global, SQL 7-344, SQL 7-427

granting

system privileges on, SQL 7-501

identification, SAD 23-7

in a newly created database, SAD 2-14

licensing by number of, SCN 29-21

licensing of, SCN 29-19

limiting number of, SAD 2-13

listed in data dictionary, SCN 2-2

listing, SAD 23-22

listing privileges granted to, SAD 24-21

listing roles granted to, SAD 24-21

local, SQL 7-344, SQL 7-426

locking accounts of, SQL 7-427

managing, SAD 23-11

maximum concurrent, SQL 7-103

multi-byte characters

in passwords, SAD 23-12

multiple, SRF 1-38

multiuser environments, SCN 1-2, SCN 8-2

objects after dropping, SAD 23-16

password encryption, SCN 29-7

password expiration of, SQL 7-427

password security, SAD 22-4

policies for managing privileges, SAD 22-5

privileges for changing passwords, SAD 23-15

privileges for creating, SAD 23-11

privileges for dropping, SAD 23-17

privileges of, SCN 1-41

processes of, SCN 1-17, SCN 8-4

profiles of, SCN 1-43, SCN 29-18

PUBLIC group, ADG 12 - 21, SAD 24-15

PUBLIC user group, SCN 29-14, SCN 30-19

removing from the database, SQL 7-483

resource limits of, SCN 29-16

restricting application roles, ADG 12 - 7

restrictions on resource use of, SCN 1-42

roles and, SCN 30-16

for types of users, SCN 30-18

schemas of, SCN 1-38, SCN 29-2

security and, SAD 22-2

security domains of, SCN 1-40, SCN 29-2, SCN 30-19

security for general users, SAD 22-4

session, terminating, SAD 4-17

specifying user names, SAD 23-12

SQL examples, SQL 7-428

tablespace quotas, SAD 23-13

tablespace quotas of, SCN 1-43, SCN 29-13

tablespaces of, SCN 1-42

temporary tablespaces for, SQL 7-427

temporary tablespaces of, SCN 1-43, SCN 4-18, SCN 29-13

unique user names, SAD 2-13, SAD 23-5

usernames, SCN 1-40, SCN 29-2

sessions and connections, SCN 8-4

viewing information on, SAD 23-23

viewing memory use, SAD 23-25

viewing tablespace quotas, SAD 23-24

USERS tablespace raw device, PSC 2-6

user/server/memory relationship, STU 27-2

USING BACKUP CONTROLFILE option

RECOVER command, SBR 14-28

USING BFILE clause

of CREATE JAVA, SQL 7-295

USING BLOB clause

of CREATE JAVA, SQL 7-295

using C structures, PC_ 17-32

USING clause, PLS 10-3

CONNECT statement, PCO 3-6

in CONNECT statement, PC_ 3-9

in the EXECUTE statement, PC_ 13-14

of ASSOCIATE STATISTICS, SQL 7-195, SQL 7-196

of CREATE DATABASE LINK, SQL 7-257

of CREATE INDEXTYPE, SQL 7-291

of CREATE OPERATOR, SQL 7-319, SQL 7-321

of FETCH statement, PC_ F-59, PCO F-46

of OPEN statement, PC_ F-93, PCO F-69

purpose of, PC_ 13-14

using in the EXECUTE statement, PCO 9-15

using indicator variables, PCO 9-15

using indicator variables in, PC_ 13-14

USING CLOB clause

of CREATE JAVA, SQL 7-295

using collection types, PC_ 17-33

using dbstring

Net8 database id specification, PC_ F-27, PCO F-18

USING INDEX clause

of ALTER MATERIALIZED VIEW, SQL 7-49

of constraint_clause, SQL 7-227

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-304

of CREATE TABLE, SQL 7-365, SQL 7-382

Using REFs in Embedded SQL, PC_ 17-33

USING ROLLBACK SEGMENT clause

of ALTER MATERIALIZED VIEW...REFRESH, SQL 7-50

of CREATE MATERIALIZED VIEW/SNAPSHOT...REFRESH, SQL 7-306

utext

Unicode datatype, OCI 5-29

utilities

control, NET 8-15

Export, SAD 1-17

finger, NET 9-11

for the database administrator, SAD 1-17

Import, SAD 1-17

O/S, using to make copies, SBR 8-25

Recovery Manager, SBR 4-2

SQL*Loader, SAD 1-17

utilities, Oracle

Export, Import, SPS B-1

UTL_COLL package, SPR 56 - 1

UTL_FILE package, SPR 57 - 1, PLS 8-17

UTL_FILE_DIR parameter, SRF 1-127

UTL_HTTP package, SPR 58 - 1, PLS 8-17

UTL_PG package, SPR 1 - 20

UTL_RAW package, SPR 59 - 1

UTL_REF package, SPR 60 - 1

downgrading, MIG 12-33

re-installing after downgrading, MIG 12-51

UTLBSTAT.SQL, STU 12-7

UTLBSTAT.SQL script, SRF 5-4

UTLCHAIN1.SQL script, MIG 8-31, SRF 5-4

compatibility, MIG 8-14

UTLCHAIN.SQL, SAD 20-8, STU 20-31

UTLCONST.SQL script, MIG 6-2, MIG 7-33, SRF 5-4

UTLDST.SQL, MIG 8-6, MIG 12-4

UTLDTREE.SQL, STU 12-7

UTLDTREE.SQL script, SRF 2-161, SRF 2-171, SRF 5-4

UTLESTAT.SQ, STU 12-7

UTLESTAT.SQL script, SRF 5-4

UTLEXCPT1.SQL script, MIG 8-31, SRF 5-4

compatibility, MIG 8-14

UTLEXCPT.SQL file, ADG 5 - 25

UTLHTTP.SQL script, SRF 5-4

UTLIP.SQL script, SRF 5-4

UTLIRP.SQL script, SRF 5-5

utljavarm.sql script, MIG 7-36

UTLLOCKT.SQ, STU 12-7

UTLLOCKT.SQL script, ADG 8 - 22, SAD 4-8, SRF 5-5

UTLPG.SQL script, SRF 5-5

UTLPWDMG.SQL script, SRF 5-5

UTLRP.SQL script, MIG 3-28, MIG 4-18, MIG 7-32, SRF 5-5

UTLSAMPL.SQL script, SRF 5-5

UTLSCLN.SQL script, SRF 5-5

UTLTKPROF.SQL script, SRF 5-5

UTLVALID.SQL script, SRF 5-5

UTLXPLAN.SQL, STU 13-2

UTLXPLAN.SQL script, SQL 7-486, SRF 5-5