Oracle8i Generic Documentation Master Index

ub1

definition, OCI 3-27

ub2

definition, OCI 3-27

ub4

definition, OCI 3-27

UID function, PCO 4-13, SQL 4-109

UMA

definition of, PSC 2-3

unary operators, PLS 2-42, SQL 3-1

unavailable option (RMAN)

change command, RMN 3-13

underscore

alternate mappings, NLS 4-10

underscores, PLS 2-5

undo, SCN 1-7

See also rollback

undo a transaction, PC_ F-98, PCO F-76

undo block statistic, STU 21-3

undo header blocks, PSA 7-5

unhandled exceptions, ADG 9-45, PLS 6-12, PLS 6-19

UNI_PLUGGABLE_SET_CHECK view, SRF 2-167

UNICODE, NLS 3-27

Unicode

and UTF-8, OCI 5-34

character set Id, OCI A-21, OCI A-23

fixed width support, OCI 5-33

OCILobRead(), OCI 15-155

OCILobWrite(), OCI 15-160

precautions, OCI 5-34

Unicode character set, PC_ 5-9

Unicode Transformation Format 8-bit (UTF-8), OID 2-26

Unicode variables, PC_ A-4

uniform disk access, PSC 2-5

uniform memory access

definition of, PSC 2-3

uninitialized object

how treated, PLS 9-24

UNION ALL operator

examples, STU 4-72, STU 4-74, STU 4-91

optimizing view queries, STU 4-77

transforming OR into, STU 4-71

UNION ALL set operator, PLS 5-6, SQL 3-13, SQL 7-579

UNION ALL view, STU 9-36

UNION operator

compound queries, STU 4-48

examples, STU 4-79, STU 4-92

optimizing view queries, STU 4-77

UNION set operator, PLS 5-6, SQL 3-13, SQL 7-579

unions

cannot be nested in host structures, PC_ 4-41

not permitted as host structures, PC_ 4-41

uniprocessor

definition of, PSC 2-3

UNIQUE clause

of constraint_clause, SQL 7-238

of CREATE INDEX, SQL 7-296

of CREATE TABLE, SQL 7-393

of SELECT, SQL 7-573

UNIQUE constraint, STU 12-10

simple subquery snapshots and, REP 3-15

unique constraints, DWG 7-3, DWG 18-58

enabling, SQL 7-407

index on, SQL 7-407

UNIQUE index, STU 12-17

unique indexes, SCN 10-24, SQL 7-296

Import, SUT 2-23

UNIQUE KEY

constraints

effect on direct path load, SUT 8-29

UNIQUE key constraints, SCN 258

combining with NOT NULL constraint, ADG 4-4

composite keys, SCN 259, SCN 261

composite keys and nulls, ADG 4-7

constraint checking, SCN 273

disabling, ADG 4-20

dropping associated indexes, SAD 14-17

enabling, ADG 4-20

enabling on creation, SAD 14-9

foreign key references when dropped, SAD 19-19

indexes associated with, SAD 14-9

indexes used to enforce, SCN 260

maximum number of columns, SCN 260

NOT NULL constraints and, SCN 261

nulls and, SCN 261

PRIMARY KEY constraint vs., ADG 4-7

size limit of, SCN 260

storage of associated indexes, SAD 14-10

when to use, ADG 4-7

unique keys, SCN 1-57, SCN 1-58, SCN 259

composite, SCN 259, SCN 261

generating, PSA 5-5

optimization, STU 4-75

searches, STU 4-37

unique queries, SQL 7-573

unique values

generating with SQL*Loader, SUT 5-56

uniqueness, STU 12-10

uniqueness constraints

Import, SUT 2-45

preventing errors during import, SUT 2-19

Universal Installer, GTK 3-58, GTK 3-62

Universal ROWID, OCI 3-6

universal ROWID, PC_ 4-8, PC_ 4-38, PC_ A-5, PCO A-3

ROWID pseudocolumns, PCO 4-32

universal rowids, PLS 2-17

universal ROWIDs (UROWIDs), GTK 3-29

Universal ROWIDs. See UROWIDs

universal rowids. See urowids

UNIX

disadvantages of signal handlers, NET 10-11

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

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

Oracle's operating system dependent call for signal handling, NET 10-11

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

starting Oracle Directory Manager on, OID 4-2

using both signal handling and Net8, NET 10-11

using signal handlers with, NET 10-10

UNIX system performance, STU 23-6

unlabeled volumes, LEG 3-19

UNLIMITED extents, SCN 197

unlimited extents, STU 20-28

UNLIMITED TABLESPACE privilege, SAD 22-18

UNLIMITED TABLESPACE system privilege, SQL 7-527

UNLOAD (DB2 file format)

not supported by SQL*Loader, SUT B-4

unmarking, OCI 13-10

objects, OCI 13-10

UNNEST hint, STU 7-32

UNNEST_SUBQUERY parameter, STU 7-32, STU 9-10

unnesting collections, SQL 7-576

examples, SQL 7-593

unnesting queries, ADO 6-12

unpinning, OCI 10-28, OCI 13-8

objects, OCI 13-8

unplanned downtime, PSC 9-3

UNRECOVERABLE, SQL 7-37, SQL 7-396

See also NOLOGGING clause

UNRECOVERABLE DATAFILE option

ALTER DATABASE statement, SAD 6-18

unrecoverable indexes

indexes, SAD 14-6

UNRECOVERABLE keyword

SQL*Loader, SUT 8-19

unrecoverable objects

and RECOVER operation, SBR 5-3

recovery

unrecoverable objects and, SBR 5-3

UNRECOVERABLE operations, SBY 5-28

backups after, SBY 4-14

unrecoverable operations

performing backups after, SBR 3-8

UNREGISTER command, NET A-78

unregistering a database from the recovery catalog, RMN 3-11

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

Unschedule a Queue Propagation, ADQ 9-69

unschedulePropagation(Session, String) - oracle.jms.AQjmsDestination.unschedulePropagation(javax.jms.Session, java.lang.String), JPR 2-72

UNSIGNED

external datatype, OCI 3-16

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

unsorted data

direct path load

SQL*Loader, SUT 8-17

unsorted indexes, SQL 7-300

unspecified access, OID 9-36

unstructured data, ADL 1-2

unsubscribe(String) - oracle.jms.AQjmsSession.unsubscribe(java.lang.String), JPR 2-182

unsubscribe(Topic, AQjmsAgent) - oracle.jms.AQjmsSession.unsubscribe(javax.jms.Topic, oracle.jms.AQjmsAgent), JPR 2-182

unsubscribe(Topic, String) - oracle.jms.AQjmsSession.unsubscribe(javax.jms.Topic, java.lang.String), JPR 2-182

unsupported functions

generic connectivity, DDS 8-6

until clause (RMAN), RMN 10-45, RMN 10-156

UNTIL TIME option

RECOVER statement, SBR 5-30

UNUSABLE clause

of ALTER INDEX, SQL 7-40

UNUSABLE indexes

function-based, SCN 114

unusable indexes, DWG 14-17

UNUSABLE LOCAL INDEXES clause

of ALTER MATERIALIZED VIEW, SQL 7-51

of ALTER TABLE, SQL 7-157

UNUSED column, SCN 10-7

unused columns

dropping, MIG 13-15

UPDATE

block access during, PSA 6-7

UPDATE ANY TABLE system privilege, SQL 7-527

UPDATE CASCADE, PC_ 9-21

UPDATE command

column values and triggers, ADG 13-16

data consistency, ADG 7-11

triggers and, ADG 13-6, ADG 13-18

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

update frequencies, DWG 8-37

update no action constraint, SCN 266

UPDATE object privilege, SQL 7-535

UPDATE privilege

revoking, SAD 23-14

UPDATE privilege for object tables, ADO 2-12, ADO 2-13

UPDATE SQL statement, PC_ F-111

UPDATE statement, PCO F-86, SCN 12, SQL 7-615

UPDATE statements

binds of greater than 4000 bytes, ADL 7-16

update windows, DWG 8-37

UPDATE_CHECK parameter, ADG 11-38

updateable snapshots, REP 1-8, SCN 428

updated locators, ADL 5-2, ADL 5-5, ADL 5-10, ADL 5-13, ADL 5-25

updates, OCI 2-34

updating

a row containing a BFILE, ADL 11-181

attributes, using ldapmodify, OID 4-14

avoid the LOB with different locators, ADL 5-8

BFILEs by selecting a BFILE from another table, ADL 11-185

BFILEs using BFILENAME(), ADL 11-182

by initializinga LOB locator bind variable

internal persistent LOBs, ADL 9-263

by selecting a LOB from another table

internal persistent LOBs, ADL 9-261

data, OID 4-12

entry data, using Oracle Directory Manager, OID 4-12

in Oracle Directory Manager, OID 4-10

LOB with PL/SQL bind variable, ADL 5-10

locking before, ADL 9-144

locking prior to, ADL 9-182, ADL 9-218, ADL 9-228

rows in tables and views, PC_ F-111, PCO F-86

subentry data, using Oracle Directory Manager, OID 4-12

with EMPTY_CLOB()/EMPTY_BLOB()

internal persistent LOBs, ADL 9-258

updating records in recovery catalog, RMN 3-18

updating rows in a table

SQL*Loader, SUT 5-33

updating tables

with parent keys, SCN 268, SCN 269

upgrade

to the cost-based optimizer, STU 10-9

upgrade catalog command (RMAN), RMN 10-158

upgrading

7.x to 8.0, OCI 1-22

7.x to 8.0 OCI, OCI 1-23

Advanced Queuing, MIG 7-31

after upgrading, MIG 8-1, MIG 8-14

applications, MIG 10-1

compatibility rules, MIG 10-5

options, MIG 10-8

relinking, MIG 10-5

definition, MIG 1-3

initialization parameters, MIG 7-18

Java, MIG 7-27

listener.ora file, MIG 8-6

manually, MIG 7-14

new administrative procedures, MIG 8-8

Oracle Forms applications, MIG 10-12

Oracle Parallel Server, MIG 7-3, MIG 7-29

rolling upgrade, MIG 1-13

Oracle Parallel Server issues, PSG 3-21

ORADIM, MIG 7-16

OUTLN user, avoid, MIG 7-3

parallel execution, MIG 8-5

paths, MIG 7-2

post upgrade, MIG 8-1, MIG 8-14

post-upgrade actions, MIG 8-1, SPR 6-1, SPR 23-1

preparing to upgrade, MIG 7-3

queue tables, MIG 7-34

recovery catalog, MIG 7-36

replication, MIG 7-24

scripts, MIG 7-20

CATALOG.SQL, MIG 7-22

CATPARR.SQL, MIG 7-29

CATPROC.SQL, MIG 7-22

CATREP.SQL, MIG 7-24

errors while running, MIG 1-11

JVMU815.SQL, MIG 7-27

rerunning, MIG 7-22

UTLRP.SQL, MIG 7-38

snapshots, MIG 7-30

specific components, MIG 7-24

SQL*Plus scripts, MIG 10-11

standby database, MIG 8-6

statistics tables, MIG 7-37

steps, MIG 7-3

supported releases, MIG 7-2

user-defined datatypes, MIG 7-35

using the Oracle Data Migration Assistant, MIG 7-7

upgrading the recovery catalog, RMN 3-43

UPPER function, ADG 5-8, SQL 4-110

uppercase characters, SRF 1-3

uppercase, defined, NET xx, PSG xxiii

UPSERT statement, DWG 14-5

URL (uniform resource locator), PLS 8-18

URLs, ADG 12-2

UROWID

Universal ROWID, OCI 3-6

UROWID datatype, GTK 3-29, PLS 2-17, SCN 12-16, SQL 2-27

UROWIDs

compatibility, MIG 9-11

downgrading, MIG 13-25

interoperability, MIG 9-27

urowids

and foreign tables, SQL 2-27

and heap-organized tables, SQL 2-28

and index-organized tables, SQL 2-27

description of, SQL 2-27

use

thread context, PC_ 11-8, PC_ F-33, PCO 12-8

use cases

full list of internal persistent LOBs, ADL 9-2, ADQ 11-2

how to interpret the diagrams, ADL xlvi

model, graphic summary of, ADL 9-1, ADQ 9-1, ADQ 11-1, ADQ 16-1

Use for Heterogeneous Services option in Net8 Assistant, NET 8-9, NET 8-51

Use Options Compatible with Net8 8.0 Clients option, MIG F-11

Use Oracle8i Release 8.0 Compatible Identification option, MIG F-11

USE ROLLBACK SEGMENT clause

of SET TRANSACTION, SQL 7-603

USE_ASYNC_CALL parameter, NET C-75

USE_CMAN parameter, NET 8-21, NET 8-30, NET 8-33, NET 8-37, NET 8-38, NET C-29

USE_CONCAT hint, SQL 2-65, STU 7-16

USE_DEDICATED_SERVER parameter, NET 8-21, NET C-30

USE_HASH hint, SQL 2-66

USE_INDIRECT_DATA_BUFFERS initialization parameter, SRF 1-120

USE_INDIRECT_DATA_BUFFERS parameter, SCN 7-14

USE_ISM initialization parameter: obsolete

USE_MERGE hint, SQL 2-66, STU 7-21

USE_NL hint, SQL 2-66, STU 7-20

USE_PLUG_AND_PLAY_listener_name parameter, MIG F-20, NET 6-64, NET C-58

USE_STORED_OUTLINES parameter, STU 10-5

of ALTER SESSION, SQL 7-95

of ALTER SYSTEM, SQL 7-118

USE_STORED_OUTLINES session parameter, GTK 3-37, SCN 129

user

moving among instances, PSA 5-17

partitioning method, PSA 5-13

PUBLIC, PSA 3-5, PSA 3-6

SYS, PSA 3-6

undo segment header blocks, PSA 7-6

user account, OAS 8-14

user configuration file

to set precompiler options, PC_ 10-4

user defined object identifiers, GTK 3-34

user entries

adding, by using ldapadd, OID 7-26

adding, by using Oracle Directory Manager, OID 7-18

modifying, by using ldapmodify, OID 7-27

modifying, by using Oracle Directory Manager, OID 7-24

user errors

database failures, SBR 1-13

definition, SBR 1-12

recovery from, SBR 6-15

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 field, in Oracle Directory Manager, OID 4-4

USER function, ADG 4-5, PCO 4-13, SQL 4-110

user locks

requesting, ADG 7-20

user login, OID 4-4

User Manager, for Oracle Enterprise Manager, PSG 6-20

user memory

allocating, OCI 2-17

user password modification event, OID 5-27

user password, encrypting, OID 5-16

user process

free list, PSC 7-10

user processes

allocate PGAs, SCN 7-15

connections and, SCN 8-4

dedicated server processes and, SCN 8-23

free list, PSA 8-6

free lists, PSC 7-21

instance shutdown errors, PSA 4-5

manual archiving, PSA 13-5

manual archiving by, SCN 362

sessions and, SCN 8-4

shared server processes and, SCN 8-20

trace files, SRF 1-121

user program interface (UPI), SCN 8-27

USER pseudocolumn, SCN 309

User Queue Tables, Selecting, ADQ 10-7

user resources

limiting, DWG 18-9

User Role, ADQ 4-7

user session, PCO 3-12, PLS 5-41

definition of, PC_ 3-15

user session handle

attributes, OCI A-12

description, OCI 2-9

setting in service context, OCI 2-10

user trace files, PSG C-10

USER_ views, SCN 2-6

USER_ALL_TABLES view, SRF 2-3, SRF 2-168

USER_ARGUMENTS view, SRF 2-5, SRF 2-168

USER_ASSOCIATIONS view, SRF 2-7

USER_AUDIT_OBJECT view, SRF 2-168

USER_AUDIT_SESSION view, SRF 2-168

USER_AUDIT_STATEMENT view, SRF 2-169

USER_AUDIT_TRAIL view, SRF 2-169

USER_CATALOG view, SRF 2-169

CAT synonym, SRF 2-93

USER_CLU_COLUMNS view, SRF 2-169

USER_CLUSTER_HASH_EXPRESSIONS view, SRF 2-169

USER_CLUSTERS view, SRF 2-169

CLU synonym, SRF 2-94

USER_COL_COMMENTS view, SQL 7-228, SRF 2-169

USER_COL_PRIVS view, SRF 2-170

USER_COL_PRIVS_MADE view, SRF 2-170

USER_COL_PRIVS_RECD view, SRF 2-170

USER_COLL_TYPES view, SRF 2-170

USER_CONS_COLUMNS view, SRF 2-170

USER_CONSTRAINTS view, SRF 2-170

USER_DB_LINKS view, DDS 2-21, SRF 2-171

USER_DEPENDENCIES view, SRF 2-171

USER_DIM_ATTRIBUTES view, SRF 2-171

USER_DIM_CHILD_OF view, SRF 2-171

USER_DIM_HIERARCHIES view, SRF 2-171

USER_DIM_JOIN_KEY view, SRF 2-172

USER_DIM_LEVEL_KEY view, SRF 2-172

USER_DIM_LEVELS view, SRF 2-172

USER_DIMENSIONS view, SRF 2-171

USER_DUMP_DEST initialization parameter, SAD 4-16, SBR 4-14, SBY 4-6, SRF 1-121, STU 6-4

USER_DUMP_DEST parameter, PSG 4-9, PSG C-10

of ALTER SYSTEM, SQL 7-119

SQL Trace parameter, STU 6-4

USER_ERRORS view, SRF 2-172

debugging stored procedures, ADG 9-42

USER_EXTENTS view, SRF 2-172

USER_FREE_SPACE view, SRF 2-172

USER_ID column

TKPROF_TABLE, STU 6-18

USER_IND_COLUMNS view, SRF 2-173

USER_IND_EXPRESSIONS view, SRF 2-173

USER_IND_PARTITIONS view, SRF 2-173

USER_IND_SUBPARTITIONS view, SRF 2-173

USER_INDEXES view, SRF 2-173, STU 12-17

filling with data, SAD 19-7

IND synonym, SRF 2-153

USER_INDEXTYPE_OPERATORS view, SRF 2-174

USER_INDEXTYPES view, SRF 2-173

USER_INTERNAL_TRIGGERS view, SRF 2-174

USER_JOBS view, SRF 2-174

jobs in system, viewing, SAD 8-14

USER_LIBRARIES view, SRF 2-174

USER_LOB_PARTITIONS view, SRF 2-174

USER_LOB_SUBPARTITIONS view, SRF 2-175

USER_LOBS view, SRF 2-174

USER_METHOD_PARAMS view, SRF 2-175

USER_METHOD_RESULTS view, SRF 2-175

USER_MVIEW_AGGREGATES view, SRF 2-175

USER_MVIEW_ANALYSIS view, SRF 2-175

USER_MVIEW_DETAIL_RELATIONS view, SRF 2-176

USER_MVIEW_JOINS view, SRF 2-176

USER_MVIEW_KEYS view, SRF 2-176

USER_MVIEWS view, SRF 2-43, SRF 2-176

USER_NESTED_TABLES view, SRF 2-176

USER_OBJ_AUDIT_OPTS view, SRF 2-177

USER_OBJECT_SIZE view, SRF 2-177

USER_OBJECT_TABLES view, SRF 2-176

USER_OBJECTS view, SRF 2-176

OBJ synonym, SRF 2-155

USER_OPANCILLARY view, SRF 2-177

USER_OPARGUMENTS view, SRF 2-177

USER_OPBINDINGS view, SRF 2-177

USER_OPERATORS view, SRF 2-177

USER_OULTINE_HINTS view

stored outline hints, STU 10-6

USER_OUTLINE_HINTS view, SRF 2-177

USER_OUTLINES view, SRF 2-178

stored outlines, STU 10-6

USER_PART_COL_STATISTICS view, SRF 2-178

USER_PART_HISTOGRAMS view, SRF 2-178

USER_PART_INDEXES view, SRF 2-178

USER_PART_KEY_COLUMNS view, SRF 2-178

USER_PART_LOBS view, SRF 2-178

USER_PART_TABLES view, SRF 2-179

USER_PARTIAL_DROP_TABS view, SRF 2-179

USER_PASSWORD_LIMITS view, SRF 2-179

USER_POLICIES view, SRF 2-179

USER_QUEUE_SCHEDULES view, SRF 2-179

USER_QUEUE_TABLES view, SRF 2-179

USER_QUEUES view, SRF 2-180

USER_REFRESH view, RAR 9-62, REP B-8, SRF 2-180

USER_REFRESH_CHILDREN view, RAR 9-62, REP B-8, SRF 2-180

USER_REFS view, SRF 2-180

USER_REGISTERED_SNAPSHOTS view, RAR 9-62, SRF 2-180

USER_REPCAT_REFRESH_TEMPLATES view, RAR 9-40

USER_REPCAT_TEMPLATE_OBJECTS view, RAR 9-41

USER_REPCAT_TEMPLATE_PARMS view, RAR 9-41

USER_REPCAT_TEMPLATE_SITES view, RAR 9-41

USER_REPCAT_USER_AUTHORIZATIONS view, RAR 9-41

USER_REPCAT_USER_PARM_VALUES view, RAR 9-42

USER_REPCATLOG view, RAR 9-40, SRF 2-2

USER_REPCOLUMN view, RAR 9-42, SRF 2-2

USER_REPCOLUMN_GROUP view, RAR 9-42, SRF 2-2

USER_REPCONFLICT view, RAR 9-42, SRF 2-2

USER_REPDDL view, RAR 9-43, SRF 2-2

USER_REPGENERATED view, SRF 2-2

USER_REPGENOBJECTS view, RAR 9-43, SRF 2-2

USER_REPGROUP view, RAR 9-43, SRF 2-2

USER_REPGROUP_PRIVILEGES view, RAR 9-43

USER_REPGROUPED_COLUMN view, RAR 9-43

USER_REPGROUPED_COLUMNS view, SRF 2-2

USER_REPKEY_COLUMNS view, RAR 9-43, SRF 2-2

USER_REPOBJECT view, RAR 9-44, SRF 2-2

USER_REPPARAMETER_COLUMN view, RAR 9-44, SRF 2-2

USER_REPPRIORITY view, RAR 9-44, SRF 2-2

USER_REPPRIORITY_GROUP view, RAR 9-44, SRF 2-2

USER_REPPROP view, RAR 9-45, SRF 2-2

USER_REPRESOL_STATS_CONTROL view, RAR 9-45, SRF 2-2

USER_REPRESOLUTION view, RAR 9-45, SRF 2-2

USER_REPRESOLUTION_METHOD view, RAR 9-45, SRF 2-2

USER_REPRESOLUTION_STATISTICS view, RAR 9-46, SRF 2-2

USER_REPSITES view, RAR 9-46, SRF 2-2

USER_RESOURCE_LIMITS view, SRF 2-180

USER_ROLE_PRIVS view, SRF 2-181

USER_RSRC_CONSUMER_GROUP_PRIVS view, SRF 2-181

USER_RSRC_MANAGER_SYSTEM_PRIVS view, SRF 2-181

USER_RULESETS view, SRF 2-181

USER_SEGMENTS view, SAD 9-39, SRF 2-182

Export and, SUT 1-9

USER_SEQUENCES view, SRF 2-182

SEQ synonym, SRF 2-162

USER_SNAPSHOT_LOGS view, RAR 9-62, SRF 2-182

USER_SNAPSHOT_REFRESH_TIMES view, RAR 9-62, SRF 2-182

USER_SNAPSHOTS view, RAR 9-62, SRF 2-182

USER_SOURCE view, ADG 9-43, SRF 2-182

USER_SUBPART_COL_STATISTICS view, SRF 2-182

USER_SUBPART_HISTOGRAMS view, SRF 2-183

USER_SUBPART_KEY_COLUMNS view, SRF 2-183

USER_SYNONYMS view, SRF 2-183

SYN synonym, SRF 2-163

USER_SYS_PRIVS view, SRF 2-183

USER_TAB_COL_STATISTICS view, SRF 2-183, STU 4-26

USER_TAB_COLUMNS

COLS synonym, SRF 2-94

USER_TAB_COLUMNS view, SRF 2-183, STU 4-26

filling with data, SAD 19-7

USER_TAB_COMMENTS view, SQL 7-228, SRF 2-184

USER_TAB_HISTOGRAMS view, SRF 2-184

USER_TAB_PARTITIONS view, SRF 2-184

USER_TAB_PRIVS view, SRF 2-184

USER_TAB_PRIVS_MADE view, SRF 2-185

USER_TAB_PRIVS_RECD view, SRF 2-185

USER_TAB_SUBPARTITIONS view, SRF 2-185

USER_TABLES table, PSA 10-4

USER_TABLES view, SRF 2-185, STU 4-26

filling with data, SAD 19-7

USER_TABLESPACES view, SRF 2-185

USER_TRIGGER_COLS view, SRF 2-186

USER_TRIGGERS view, SRF 2-185

USER_TS_QUOTAS view, SRF 2-186

USER_TYPE_ATTRS view, SRF 2-186

USER_TYPE_METHODS view, SRF 2-186

USER_TYPES view, SRF 2-186

USER_UPDATABLE_COLUMNS view, SCN 10-17, SRF 2-186

USER_USERS view, SRF 2-187

USER_USTATS view, SRF 2-187

USER_VARRAYS view, SRF 2-187

USER_VIEWS view, SRF 2-187

user-created backup files

cataloging, RMN 3-35

user-created objects

in SYS schema, MIG 9-25

user-defined callback functions, OCI 9-10

registering, OCI 9-10

user-defined costs, SCN 141, STU 4-33

user-defined datatypes, ADO 2-1 to ADO 2-16, SCN 13-1, SCN 13-3

collections, SCN 13-11

nested tables, ADO 1-9, SCN 13-12

variable arrays (VARRAYs), ADO 1-8, SCN 13-11

downgrading, MIG 13-29

Export and Import, ADO 2-15

incomplete types, ADO 2-14

interoperability, MIG 9-29

new format, MIG 9-29

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

use of table aliases, ADO 2-7

object-relational model, SCN 1-21

privileges, ADO 2-10

See also object-relational model

storage, ADO 7-1

upgrading, MIG 7-35

user-defined errors, ADG 9-43, ADG 9-44

user-defined exceptions, PLS 6-7

user-defined functions, SQL 4-118

name precedence of, SQL 4-119

naming conventions, SQL 4-120

restrictions on, SQL 7-286

user-defined object identifiers

compatibility, MIG 9-11

downgrading, MIG 13-30

user-defined operator, SCN 10-48

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

user-defined record, PC_ 7-5, PCO 6-6

user-defined records, PLS 4-42

user-defined statistics

dropping, SQL 7-478, SQL 7-480, SQL 7-482, SQL 7-492, SQL 7-501, SQL 7-506

user-defined stored function

used in WHERE clause, PC_ 6-10

user-defined subtypes, PLS 2-25

user-defined type equivalencing, PC_ F-110

user-defined types

categories of, SQL 2-30

defining, SQL 7-440

USERENV function, ADG 11-42, SQL 4-111

USERENV namespace, ADG 11-42, ADG 11-43

USERID

Export parameter, SUT 1-27

Import parameter, SUT 2-30

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-6

user-level DLM, PSC 5-34

USERLOCK.SQL script, SRF 5-4

user-mode Export

specifying, SUT 1-22

user-mode interprocess communication

how used in Oracle Parallel Server, PSC 2-4

user-mode IPCs

and Cache Fusion, PSA 12-4, PSA 12-5

usernames

as reported in a trigger, ADG 13-26

defining, PC_ 3-2, PCO 3-2

hardcoding, PCO 3-2

schemas, ADG 11-19

SYS and SYSTEM, SAD 1-4

users, SCN 280

access rights, SCN 280

allocating space for, SQL 7-453

altering, SAD 22-19

assigning

default roles, SQL 7-195

profiles, SQL 7-453

assigning profiles to, SAD 22-23

assigning tablespace quotas, SAD 9-3

assigning unlimited quotas for, SAD 22-17

associated with schemas, SCN 10-2

auditing, SCN 340

authenticating, SRF 1-90

authenticating to a remote server, SQL 7-275

authentication

about, SAD 21-2, SAD 22-7

authentication of, SCN 281

authorize for deployment template, RAR 4-10

changing default roles, SAD 22-20

changing global authentication, SQL 7-195

coordinating concurrent actions of, SCN 1-29

creating, SQL 7-451

creating for master sites, RAR 2-6

database authentication, SAD 22-8

dedicated servers and, SCN 8-23

default tablespaces, SAD 22-16

default tablespaces of, SCN 292, SQL 7-453

definitions

importing, SUT 2-13

denying access to tables and views, SQL 7-547

dropped roles, ADG 11-27

dropping, SAD 22-20

dropping profiles and, SAD 22-25

dropping roles and, SAD 23-10

enabling roles for, ADG 11-9

end-user security policies, SAD 21-6

enrolling, SAD 1-20

enterprise, ADG 11-19, SAD 22-11, SAD 23-9, SCN 280

external, SQL 7-366, SQL 7-452

external authentication, SAD 22-9

global, SAD 22-11, SQL 7-366, SQL 7-452

granting

system privileges on, SQL 7-528

in a newly created database, SAD 2-25

licensing by number of, SCN 300

licensing of, SCN 298

limiting number of, SAD 2-24

listed in data dictionary, SCN 2-2

listing, SAD 22-25

listing privileges granted to, SAD 23-23

listing roles granted to, SAD 23-24

local, SQL 7-366, SQL 7-452

locking accounts of, SQL 7-453

locks, SCN 250

managing, SAD 22-14

maximum concurrent, SQL 7-112

memory allocation, STU 19-8

multiple, SRF 1-36

multi-tier authentication and authorization, SAD 22-13

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

network authentication, SAD 22-11

objects after dropping, SAD 22-20

operating system authentication, SAD 22-10

password encryption, SCN 285

password expiration of, SQL 7-453

password security, SAD 21-5

policies for managing privileges, SAD 21-6

privileges for changing passwords, SAD 22-18

privileges for creating, SAD 22-15

privileges for dropping, SAD 22-20

privileges of, SCN 1-40

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

profiles of, SCN 1-42, SCN 298

PUBLIC group, ADG 11-34, SAD 23-16

PUBLIC user group, SCN 294, SCN 322

removing from the database, SQL 7-509

resource limits of, SCN 295

restricting application roles, ADG 11-12

restrictions on resource use of, SCN 1-41

roles and, SCN 319

for types of users, SCN 321

schema-independent, ADG 11-19, SAD 22-12

schemas of, SCN 1-37, SCN 280

security and, SAD 21-2

security domains of, SCN 1-39, SCN 280, SCN 322

security for general users, SAD 21-4

session, terminating, SAD 4-22

snapshot sites, RAR 2-16

specifying user names, SAD 22-15

SQL examples, SQL 7-453

tablespace quotas, SAD 22-17

tablespace quotas of, SCN 1-42, SCN 292

tablespaces of, SCN 1-41

temporary tablespaces for, SQL 7-453

temporary tablespaces of, SCN 1-42, SCN 4-20, SCN 293

unique user names, SAD 2-24, SAD 22-6

usernames, SCN 1-39, SCN 280

sessions and connections, SCN 8-4

viewing information on, SAD 22-27

viewing memory use, SAD 22-29

viewing tablespace quotas, SAD 22-27

USERS tablespace

described, PSG 1-12

raw device, PSG 2-6

USING BACKUP CONTROLFILE option

RECOVER statement, SBR 5-27

USING BFILE clause

of CREATE JAVA, SQL 7-314

USING BLOB clause

of CREATE JAVA, SQL 7-314

using C structures, PC_ 17-32

USING clause, PLS 10-3, PLS 11-62

CONNECT statement, PCO 3-6

in CONNECT statement, PC_ 3-9

in the EXECUTE statement, PC_ 13-14

of ASSOCIATE STATISTICS, SQL 7-211, SQL 7-212

of CREATE DATABASE LINK, SQL 7-275

of CREATE INDEXTYPE, SQL 7-310

of CREATE OPERATOR, SQL 7-339, SQL 7-341

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

of OPEN statement, PC_ F-92, PCO F-71

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-314

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-52

of constraint_clause, SQL 7-244

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-324

of CREATE TABLE, SQL 7-389, SQL 7-407

Using REFs in Embedded SQL, PC_ 17-34

USING ROLLBACK SEGMENT clause

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

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

utext

Unicode datatype, OCI 5-34

UTF8, NLS A-17

UTF-8. See Unicode Transformation Format 8-bit

UTF8 support, NLS A-18

utilities

for the database administrator, SAD 1-17

Import, SAD 1-17

operating system, using to make copies, RMN 5-27

SQL*Loader, SAD 1-17

tftp, NET 10-9

utilities, Oracle

Export, Import, PSC B-2

UTL_COLL package, SPR 59-1

UTL_FILE package, SPR 60-1, PLS 8-18

UTL_FILE_DIR initialization parameter, SRF 1-121

UTL_FILE_DIR parameter, DWG 14-19

UTL_HTTP package, ADG 12-2, SPR 61-1, PLS 8-18

UTL_INADDR package, ADG 12-1, SPR 62-1

UTL_PG package, SPR 1-21

UTL_RAW package, SPR 63-1

UTL_REF package, SPR 64-1

downgrading, MIG 13-41

re-installing after downgrading, MIG 13-62

UTL_SMTP package, ADG 12-1, SPR 65-1

UTL_TCP package, ADG 12-1, SPR 66-1

UTLBSTAT

for recording statistics, PSA 11-2

UTLBSTAT.SQL, OID 13-3

UTLBSTAT.SQL script, SRF 5-4, STU 11-7

UTLCHAIN.SQL script, SAD 19-9

UTLCHN1.SQL script, MIG 9-31, SRF 5-4, STU 11-7, STU 20-31

compatibility, MIG 9-13

UTLCHN.SQL script, SQL 7-207

UTLCONST.SQL script, MIG 8-4, SRF 5-4

UTLDST.SQL script, MIG 9-6, MIG 13-9

UTLDTREE.SQL script, SRF 2-142, SRF 2-153, SRF 5-4, STU 11-7

UTLESTAT

for recording statistics, PSA 11-2

UTLESTAT.SQL, OID 13-3

UTLESTAT.SQL script, SRF 5-4, STU 11-7

UTLEXPT1.SQL script, MIG 9-31, SQL 7-163, SQL 7-245, SQL 7-407, SRF 5-5

compatibility, MIG 9-13

UTLHTTP.SQL script, SRF 5-5

UTLIP.SQL script, SRF 5-5

UTLIRP.SQL script, SRF 5-5

UTLJAVARM.SQL, SRF 5-8

UTLJAVARM.SQL script, SRF 5-8

UTLLOCKT.SQL script, ADG 7-21, SAD 4-15, SRF 5-5, STU 11-7

UTLPG.SQL script, SRF 5-5

UTLPWDMG.SQL script, SRF 5-5

UTLRP.SQL script, MIG 4-33, MIG 5-21, MIG 7-38, SRF 5-5

UTLSAMPL.SQL script, SRF 5-5

UTLSCLN.SQL script, SRF 5-6

UTLTKPROF.SQL script, SRF 5-6

UTLVALID.SQL script, SRF 5-6

UTLXPLAN.SQL script, SQL 7-512, SRF 5-6, STU 5-3