Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i Generic Documentation Master Index


U

U number format element, SQL 2-41
U0703040.SQL script, MIG 4-32
U703040.SQL script, SRF 5-7
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
embedded SQL examples, PC_ F-115, PCO F-90
example, PCO 5-10
example of, PC_ 6-9
foreign key references, SCN 266
freeing space in data blocks, SCN 4-10
no-logging mode, SCN 152
LOBs, SCN 151
parallel UPDATE, SCN 178
purpose of, PC_ 6-9
RETURNING clause, PLS 5-64
SET clause, PCO 5-11
SET clause in, PC_ 6-10
syntax, PLS 11-172
triggers, SCN 82, SCN 87
BEFORE triggers, SCN 90
triggers on, SQL 7-429
using host arrays in, PC_ 8-12
using host tables, PCO 7-13
WHERE clause in, PC_ 6-10
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
at different times, PSC 8-6
concurrent, PSC 1-4
free lists, PSA 1-6
instance lock, PSC 5-22
locating free space, SRF 1-47
location transparency and, DDS 1-45, SCN 415
object views, ADO 5-11, SCN 14-5
PCM locks, PSC 4-12
performance, PSC 7-19
piecewise, OCI 5-37, OCI 5-39
positioned, OCI 2-34
transaction processing option, SRF 1-106
transparency, DDS 2-32
updatability of object views, SCN 14-5
updatability of views, SCN 10-16, SCN 93, SCN 94
updatable join views, SCN 10-16
update intensive environments, SCN 219
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
UTFE, NLS A-17
utilities
control, NET 11-3
Export, SAD 1-17
finger, NET 10-9
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

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents