Oracle8i Generic Documentation Master Index
Release 8.1.5

A68826-01

Library

Product

Contents

Index

Prev Top Next


O

O2F, SMS 35-1
O2I, SMS 36-1
O2U, SMS 37-1
O7_DICTIONARY_ACCESSIBILITY parameter, SRF 1-13
compatibility, MIG 8-24, MIG B-8
OBJ synonym for USER_OBJECTS, SRF 2-174
object, PLS 9-4
declaring, PLS 9-22
initializing, PLS 9-23
manipulating, PLS 9-30
sharing, PLS 9-27
object access expressions, SQL 5-10
object applications
commit, OCI 13-14
database connection, OCI 10-10
rollback, OCI 13-14
object attribute, PLS 9-3, PLS 9-7
accessing, PLS 9-24
allowed datatypes, PLS 9-7
maximum number, PLS 9-7
object cache, ADL 2-14, GTK 2-35, GTK 2-36, GTK 3-12, OCI 13-2, PC_ 17-4, SQL 7-86, SQL 7-107
coherency, OCI 13-4
consistency, OCI 13-4
flushing an object, ADG 19 - 13
initializing, OCI 10-10
loading objects, OCI 13-7
LOBs, ADL 2-14
memory parameters, OCI 13-5
object views, SCN 15-4
OCI, SCN 13-14
operations on, OCI 13-6
privileges, SCN 14-16
Pro*C, SCN 13-14
removing objects, OCI 13-7
setting the size of, OCI 13-5
object columns, indexes on, ADG 6 - 7
object constructor
calling, PLS 9-25
passing parameters to, PLS 9-26
OBJECT CREATE SQL statement, PC_ 17-9, PC_ F-84
Object Database Designer, GTK 3-13
OBJECT DELETE SQL statement, PC_ 17-11, PC_ F-85
OBJECT DEREF SQL statement, PC_ 17-10, PC_ F-86
OBJECT FLUSH SQL statement, PC_ F-87
OBJECT FLUSH SQL statements, PC_ 17-12
object functions
See navigational functions.
server roundtrips, OCI C-4
OBJECT GET SQL statement, PC_ 17-16, PC_ F-88
object identifier
for persistent objects, OCI 10-5
object identifier (OID)
with CREATE TYPE, DCI 3-3
OBJECT IDENTIFIER clause
of CREATE TABLE, SQL 7-377
object identifiers, ADG 16 - 28, SCN 15-3, SUT 2-57
contained in REFs, SQL 2-26
Export, SUT 1-56
for object types, SCN 14-18
for object views, SCN 15-3, SCN 15-4
of object views, SQL 7-433
primary key, SQL 7-377
primary-key based, ADG 18 - 8
REFs, ADG 18 - 9
specifying, SQL 7-377
specifying an index on, SQL 7-377
storage, ADG 18 - 8
system-generated, SQL 7-377
WITH OBJECT OID clause, SCN 15-3, SCN 15-4
object method, PLS 9-3, PLS 9-8
calling, PLS 9-26
object names
resolving partial, DDS 2-17
SQL*Loader, SUT 5-18
object privileges, SCN 30-3
granting, SQL 7-343
multiple, SQL 7-347
on specific columns, SQL 7-506
to a role, SQL 7-505
to a user, SQL 7-505
to PUCLIC, SQL 7-506
on a database object
revoking, SQL 7-534
on a directory
revoking, SQL 7-533
revoking
all, from a user, SQL 7-533
from a role, SQL 7-532, SQL 7-533
from a user, SQL 7-532, SQL 7-533
from all users, SQL 7-534
from PUBLIC, SQL 7-533
See also schema object privileges
object reference, OCI 10-33
object reference functions, SQL 4-4
object reference. See REF
object relational enhancements, GTK 2-33 to GTK 2-37
ANALYZE command, dangling REFs, GTK 2-36
collection unnesting, GTK 2-35
object cache enhancements, GTK 2-36
object identifiers, user defined, GTK 2-34
object views, GTK 2-35
parallel query support, GTK 2-37
partitioning of tables containing user-defined types, GTK 2-37
referential integrity constraint on REF column, GTK 2-34
SQL*Loader support, GTK 2-36
value subqueries, GTK 2-36
see also LOBs
see also nested tables
see also varrays
OBJECT RELEASE SQL statement, PC_ F-89
object runtime environment
initializing, OCI 10-10
OBJECT SET SQL statement, PC_ 17-14, PC_ F-90
object support, SUT 3-23
object support in OO4O, ADG 1 - 17
object table, PLS 9-30
object tables, ADG 16 - 26, ADG 18 - 8, SCN 13-3, SCN 13-7
adding rows to, SQL 7-513
constraints, SCN 14-5
creating, SQL 7-358
deleting values, ADG 16 - 41
Import, SUT 2-58
indexes, SCN 14-6
inserting values, ADG 16 - 36
loading, SUT 5-96
partitioned
downgrading, MIG 12-16
querying, ADG 16 - 39
row objects, SCN 13-8
triggers, SCN 14-6
virtual object tables, SCN 15-2
object type, DCI 1-8, PLS 9-1, PLS 9-3
advantages, PLS 9-5
attributes, DCI 1-15, DCI 11-2
body code, DCI 1-16
comparisons, DCI 3-5
defining, PLS 9-12
examples, PLS 9-12
methods, DCI 11-2
specification, DCI 1-15
structure, PLS 9-5
syntax, PLS 11-105
object type bodies
creating, SQL 7-422
re-creating, SQL 7-422
SQL examples, SQL 7-424
object type definitions
exporting, SUT 1-56
importing, SUT 2-58
object type identifiers, SUT 2-30
object type tables
creating, SQL 7-367
Object Type Translator, GTK 3-12
object type translator
sample output, OCI 10-9
See OTT
use with OCI, OCI 10-8
Object Type Translator (OTT), PC_ A-4
command line, PC_ 19-6
command line syntax, PC_ 19-26
creating types in the database, PC_ 19-5
datatype mappings, PC_ 19-10
default name mapping, PC_ 19-38
outtype file, PC_ 19-17
parameters, PC_ 19-27 to PC_ 19-31
providing an intype file, PC_ 19-8
reference, PC_ 19-25
restriction, PC_ 19-39
using, PC_ 19-1, PC_ 19-2
using with Pro*C/C++, PC_ 19-22
object type values
comparing, SQL 7-417, SQL 7-423
Object Types, PC_ A-3
object types, GTK 3-11, SCN 1-22, SCN 13-2, SCN 13-4, SQL 2-26
adding new member subprograms, SQL 7-174
associating functions or procedures, SQL 7-174
attributes, SQL 2-77
attributes of, SCN 13-2, SCN 13-4
column objects, SCN 13-8
indexes, SCN 14-6
column objects vs. row objects, ADG 18 - 2
comparison methods for, ADG 16 - 22, SCN 13-6
comparison rules, SQL 2-30
MAP function, SQL 2-30
ORDER function, SQL 2-30
compiling the specification and body, SQL 7-174
components of, SQL 2-26
constructor methods for, SCN 1-57, SCN 13-6, SCN 14-18
creating, SQL 7-411, SQL 7-413
defining member methods of, SQL 7-422
disassociating statistics types from, SQL 7-480
dropping the body of, SQL 7-482
dropping the specification of, SQL 7-480
function subprogram
declaring, SQL 7-423
function subprogram of
specifying, SQL 7-416
function subprograms of, SQL 7-415, SQL 7-422
incomplete, ADG 16 - 16, SCN 14-17, SQL 7-413
invoker-rights, ADG 18 - 30
locking in cache, SCN 13-15
message queuing, SCN 19-6
methods, SQL 2-77
methods of, ADG 16 - 23, SCN 1-57, SCN 13-4
method calls, SCN 14-9
PL/SQL, SCN 13-14
purchase order example, SCN 13-2, SCN 13-5
mutually dependent, SCN 14-16
object views, SCN 10-16
Oracle type translator, SCN 13-15
parallel query, SCN 26-29
restrictions, SCN 26-30
procedure subprogram
declaring, SQL 7-423
procedure subprogram of
specifying, SQL 7-416
procedure subprograms of, SQL 7-415, SQL 7-422
purchase order example, SCN 13-2, SCN 13-4
restrictions
parallel DDL, SCN 26-31
parallel DML, SCN 26-44
row objects, SCN 13-8
SQL examples, SQL 7-418
statistics types, SQL 7-195
use of table aliases, SCN 14-8
user-defined
creating, SQL 7-414
OBJECT UPDATE SQL statement, PC_ 17-12, PC_ F-91
object views, ADG 17 - 2, GTK 2-35, GTK 3-11, GTK 3-12, SCN 10-16, SCN 15-1
adding rows to the base table of, SQL 7-513
advantages, ADG 17 - 3
advantages of, SCN 15-2
defining, SCN 15-3, SQL 7-430
modifiability, SCN 20-12
nested tables, SCN 15-5
object identifiers for, SCN 15-3, SCN 15-4
updating, ADG 17 - 15, SCN 15-5
use of INSTEAD OF triggers with, SCN 15-5
OBJECT_CACHE_MAX_SIZE_PERCENT parameter, SRF 1-83
of ALTER SESSION, SQL 7-86
of ALTER SYSTEM, SQL 7-107
OBJECT_CACHE_OPTIMAL_SIZE parameter, SRF 1-83
of ALTER SESSION, SQL 7-86
of ALTER SYSTEM, SQL 7-107
OBJECT_INSTANCE column
PLAN_TABLE table, STU 13-4
OBJECT_NAME column
PLAN_TABLE table, STU 13-4
OBJECT_NODE column
PLAN_TABLE table, STU 13-4
OBJECT_OWNER column
PLAN_TABLE table, STU 13-4
OBJECT_TYPE column
PLAN_TABLE table, STU 13-4
object-identifiers
user-defined
downgrading, MIG 12-22
object-oriented programming, PLS 9-1
object-relational DBMS (ORDBMS), SCN 1-22, SCN 13-2
object-relational model, ADG 16 - 1
comparing objects, ADG 18 - 8
constraints, ADG 18 - 39
design considerations, ADG 18 - 1
embedded objects, ADG 16 - 28
implementing with object tables, ADG 16 - 16
inheritance, ADG 18 - 33
limitations of relational model, ADG 16 - 13
methods, ADG 18 - 27
new object format, ADG 18 - 33
partitioning, ADG 16 - 41
programmatic environments for, ADG 19 - 1
replication, ADG 18 - 33
type evolution, ADG 18 - 40
object-relational technology, GTK 3-10
Objects, SUT 3-16
objects, SUT 3-20
accessing with OCI, OCI 14-19, PC_ 19-19
allocation duration, OCI 13-14
altering in a master group, REP 2-28
array pin, OCI 10-13
attributes, OCI 10-17
manipulating, OCI 10-13
client-side cache, OCI 13-2
collection objects, ADG 17 - 6
considerations for Importing, SUT 2-57
copying, OCI 10-32
creating, OCI 10-32
creation errors, SUT 2-48
data dictionary, SRF 2-1
definitions
replication to master sites, REP 2-26
duration, OCI 13-14
flushing, OCI 13-10
flushing changes, OCI 10-14
freeing, OCI 10-32, OCI 13-9
ignoring existing objects during import, SUT 2-24
import creation errors, SUT 2-24
in columns, ADG 17 - 4
introduction to, PC_ 17-2
lifetime, OCI 16-2
loading column objects, SUT 5-91
loading nested column objects, SUT 5-93
LOB attribute of, OCI 7-5
LOB attributes of transient objects, OCI 7-6
locking, OCI 13-12
manipulating with OCI, OCI 14-19, PC_ 19-19
marking, OCI 10-14, OCI 13-9
master groups
generating support for, REP 2-36
memory layout of instance, OCI 13-16
memory management, OCI 13-2
meta-attributes, OCI 10-17
navigation, OCI 13-17
simple, OCI 13-17
NULL values, SUT 5-93
nullness, OCI 10-29
object references, ADG 17 - 8
OCI object application structure, OCI 10-4
persistent, OCI 10-5, OCI 10-6, PC_ 17-4
persistent versus transient copies of, PC_ 17-4
pin count, OCI 10-28
pin duration, OCI 13-14
pinning, OCI 10-12, OCI 13-7
privileges, SUT 2-11
privileges on, SCN 30-11
references to, PC_ 17-2
referencing with synonyms, DDS 2-22
refreshing, OCI 13-11
removing from master groups, REP 2-30
replicated
re-creating, REP 7-32
restoring sets
Import, SUT 2-43
row objects and object identifiers, ADG 17 - 6
secondary memory, OCI 13-16
stream record format, SUT 5-91
support, PC_ 17-1
terminology, OCI 16-2
top-level memory, OCI 13-16
transient, OCI 10-5, OCI 10-7, PC_ 17-4
types, OCI 10-5, OCI 16-2, PC_ 17-2
unmarking, OCI 13-10
unpinning, OCI 10-28, OCI 13-8
use with OCI, OCI 10-3
using object types in Pro*C/C++, PC_ 17-3
variable record format, SUT 5-92
Objects for OLE, GTK 2-86
objects in a database schema, SCN 1-5
See also schema objects
objects owned by SYS
and TSPITR using RMAN, SBR A-6
Objects page
Create New Master Group property sheet, REP 2-19
OBJECTS precompiler option, PC_ 10-33, PC_ 17-20
objects. See object types or database objects.
objects, schema
cascading effects on revoking, SAD 24-15
default tablespace for, SAD 23-13
granting privileges, ADG 12 - 17, SAD 24-10
in a revoked tablespace, SAD 23-14
listing information, ADG 3 - 50
name resolution, ADG 3 - 46
owned by dropped users, SAD 23-16
privileges with, SAD 24-3
renaming, ADG 3 - 48
revoking privileges, ADG 12 - 19, SAD 24-13
when revoking object privileges, ADG 12 - 21
obsolete parameters, SPS A-20, SPS A-21
obsolete parameters in release 8.1, NET 4-20, NET 5-4
obsolete procedures, REP B-13
OCI, SCN 8-25
accessing and manipulating objects, OCI 14-19
advantages, ADG 1 - 8, OCI 1-3
anonymous blocks, SCN 16-17
bind variables, SCN 16-13
compatibility, MIG 8-17
client notification, MIG 8-9
link line, MIG 8-18
thread safety, MIG 8-18
declaring LDA, PCO 3-16
embedding calls, PCO 3-16
interoperability, MIG 8-17
Oracle7 clients, MIG 8-18
shared structures, MIG 8-17
LOB manipulation functions, DCI 6-6
new features, OCI 1-12
object cache, ADG 17 - 23, SCN 13-14
object support, OCI 1-6
OCIChangePassword call, MIG 8-37
OCIObjectFlush, SCN 15-4
OCIObjectPin, SCN 15-4
OCISessionBegin call, MIG 8-37
overview, ADG 1 - 7, OCI 1-2
parts of, ADG 1 - 8, OCI 1-5
stored procedures, SCN 16-18
upgrading applications to Oracle8i, MIG 9-2
using with Oracle Precompilers, PCO 3-16
OCI application
compiling, OCI 1-4
general structure, OCI 2-3
initialization example, OCI 2-24
linking, OCI 1-4
steps, OCI 2-17
structure, OCI 2-3
structure using objects, OCI 10-4
terminating, OCI 2-26
using the OTT with, OCI 14-18
with objects
initializing, OCI 10-10
OCI applications
using the OTT with, PC_ 19-18
OCI calls, PC_ 1-8
embedding, PC_ 5-50
in an X/A environment, PC_ 5-56
OCI enhancements, GTK 2-83
API to append data to LOB, GTK 2-34
AQ support, GTK 2-38
array DMLs, GTK 2-84
asynchronous event notification, GTK 2-84
collection locator, GTK 2-34
direct path load, GTK 2-24
DML returning, GTK 2-83
LOBs, GTK 2-34
NLS interface, GTK 2-43
non-blocking OCI, GTK 2-85
object cache, GTK 2-36
OCI callback registrations, GTK 2-84
OCIDescribeAny, GTK 2-84
Open/Close/IsOpen API for LOBS, GTK 2-34
UCS2 (fixed-width Unicode) support, GTK 2-43
OCI environment
initializing for objects, OCI 10-10
OCI functions
canceling calls, OCI 2-33
codes, OCI 15-230
data cartridges, OCI 2-3
new and updated calls, OCI 1-12
NLS, OCI 2-3
not supported, OCI 1-21
obsolescent, OCI 1-19
return codes, OCI 2-27, OCI 2-29
OCI navigational functions, OCI 13-19
flush functions, OCI 13-20
mark functions, OCI 13-20
meta-attribute accessor functions, OCI 13-20
miscellaneous functions, OCI 13-21
naming scheme, OCI 13-19
pin/unpin/free functions, OCI 13-19
OCI non-deferred linking, GTK 6-4
OCI onblon() call
not used to connect, PC_ 5-50
OCI orlon() call
not used to connect, PC_ 5-50
OCI process
initializing for objects, OCI 10-10
OCI program. See OCI application
OCI relational functions
advanced queuing and publish-subscribe, OCI 15-4
connect, authorize, and initialize, OCI 15-87
guide to reference entries, OCI 18-2
OCI Release 8, PC_ 5-45
accessing and manipulating objects, PC_ 19-19
embedding in Pro*C/C++, PC_ 5-48
interfacing to, PC_ 5-46
parameters in the environment handle, PC_ 5-46
SQLLIB extensions, PC_ 5-45
OCI single-task linking, GTK 6-5
OCI support for client notification, GTK 2-38
see also OCI enhancements, asynchronous event notification
OCI types
declaring, PC_ 17-34
manipulating, PC_ 17-35
OCIDate, PC_ 17-34
OCINumber, PC_ 17-34
OCIRaw, PC_ 17-34
OCIString, PC_ 17-34
using in embedded SQL, PC_ 17-34
OCI_ATTR_ALLOC_DURATION
environment handle attribute, OCI A-4
OCI_ATTR_AUTOCOMMIT_DDL
attribute, OCI 6-20
OCI_ATTR_BUF_ADDR, OCI A-43
OCI_ATTR_BUF_SIZE, OCI A-39, OCI A-43
OCI_ATTR_CACHE
attribute, OCI 6-15
OCI_ATTR_CACHE_ARRAYFLUSH
environment handle attribute, OCI A-3
OCI_ATTR_CACHE_MAX_SIZE
environment handle attribute, OCI A-3
OCI_ATTR_CACHE_OPT_SIZE
environment handle attribute, OCI A-3
OCI_ATTR_CATALOG_LOCATION
attribute, OCI 6-20
OCI_ATTR_CHAR_COUNT
bind handle attribute, OCI A-20
define handle attribute, OCI A-22
use of, OCI 5-28
OCI_ATTR_CHARSET_FORM
attribute, OCI 6-11, OCI 6-14, OCI 6-16
bind handle attribute, OCI A-20
define handle attribute, OCI A-23
OCI_ATTR_CHARSET_ID, OCI A-39, OCI A-46
attribute, OCI 6-11, OCI 6-14, OCI 6-16, OCI 6-18, OCI 6-19
bind handle attribute, OCI A-20
define handle attribute, OCI A-22
OCI_ATTR_CLUSTERED
attribute, OCI 6-7
OCI_ATTR_COL_COUNT, OCI A-42
OCI_ATTR_COLLECTION_ELEMENT
attribute, OCI 6-9
OCI_ATTR_COLLECTION_TYPECODE
attribute, OCI 6-9
OCI_ATTR_COMPLEXOBJECT_ COLL_OUTOFLINE
COR handle attribute, OCI A-25
OCI_ATTR_COMPLEXOBJECT_LEVEL
COR handle attribute, OCI A-25
OCI_ATTR_COMPLEXOBJECTCOMP _TYPE_LEVEL
COR descriptor attribute, OCI A-26
OCI_ATTR_COMPLEXOBJECTCOMP_TYPE
COR descriptor attribute, OCI A-26
OCI_ATTR_CURSOR_COMMIT_ BEHAVIOR
attribute, OCI 6-20
OCI_ATTR_DATA_SIZE, OCI A-47
attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-16
OCI_ATTR_DATA_TYPE, OCI A-47
attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-16
OCI_ATTR_DATE_FORMAT, OCI A-39
OCI_ATTR_DATEFORMAT, OCI A-47
OCI_ATTR_DBA
attribute, OCI 6-7
OCI_ATTR_DIRPATH_MODE, OCI A-40
OCI_ATTR_DIRPATH_NOLOG, OCI A-40
OCI_ATTR_DIRPATH_PARALLEL, OCI A-40
OCI_ATTR_DML_ROW_OFFSET, OCI A-6
OCI_ATTR_DURATION
attribute, OCI 6-7
OCI_ATTR_ENCAPSULATION
attribute, OCI 6-11
OCI_ATTR_ENV
server handle attribute, OCI A-9
service context handle attribute, OCI A-7
OCI_ATTR_EXTERNAL_NAME
server handle attribute, OCI A-9
OCI_ATTR_FOCBK
server handle attribute, OCI A-10
OCI_ATTR_HAS_DEFAULT
attribute, OCI 6-17
OCI_ATTR_HAS_FILE
attribute, OCI 6-9
OCI_ATTR_HAS_LOB
attribute, OCI 6-9
OCI_ATTR_HAS_NESTED_TABLE
attribute, OCI 6-9
OCI_ATTR_HW_MARK
attribute, OCI 6-15
OCI_ATTR_IN_V8_MODE
server handle attribute, OCI A-10
service context handle attribute, OCI A-8
OCI_ATTR_INCR
attribute, OCI 6-14
OCI_ATTR_INDEX_ONLY
attribute, OCI 6-7
OCI_ATTR_INTERNAL_NAME
server handle attribute, OCI A-10
OCI_ATTR_IOMODE
attribute, OCI 6-17
OCI_ATTR_IS_CONSTRUCTOR
attribute, OCI 6-11
OCI_ATTR_IS_DESTRUCTOR
attribute, OCI 6-11
OCI_ATTR_IS_INCOMPLETE_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_INVOKER_RIGHTS
attribute, OCI 6-8, OCI 6-10
OCI_ATTR_IS_MAP
attribute, OCI 6-12
OCI_ATTR_IS_NULL
attribute, OCI 6-15, OCI 6-17
OCI_ATTR_IS_OPERATOR
attribute, OCI 6-11
OCI_ATTR_IS_ORDER
attribute, OCI 6-12
OCI_ATTR_IS_PREDEFINED_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_RNDS
attribute, OCI 6-12
OCI_ATTR_IS_RNPS
attribute, OCI 6-12
OCI_ATTR_IS_SELFISH
attribute, OCI 6-12
OCI_ATTR_IS_SYSTEM_GENERATED_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_SYSTEM_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_TEMPORARY
attribute, OCI 6-7
OCI_ATTR_IS_TRANSIENT_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_WNDS
attribute, OCI 6-12
OCI_ATTR_IS_WNPS
attribute, OCI 6-12
OCI_ATTR_LEVEL
attribute, OCI 6-17
OCI_ATTR_LINK
attribute, OCI 6-14, OCI 6-18
OCI_ATTR_LIST_ARGUMENTS
attribute, OCI 6-8, OCI 6-11
OCI_ATTR_LIST_COLUMNS, OCI A-40
attribute, OCI 6-7
OCI_ATTR_LIST_OBJECTS
attribute, OCI 6-19
OCI_ATTR_LIST_SCHEMAS
attribute, OCI 6-19
OCI_ATTR_LIST_SUBPROGRAMS
attribute, OCI 6-8
OCI_ATTR_LIST_TYPE
attribute, OCI 6-18
OCI_ATTR_LIST_TYPE_ATTRS
attribute, OCI 6-10
OCI_ATTR_LIST_TYPE_METHODS
attribute, OCI 6-10
OCI_ATTR_LOBEMPTY
LOB locator attribute, OCI A-25
OCI_ATTR_LOCKING_MODE
attribute, OCI 6-20
OCI_ATTR_MAP_METHOD
attribute, OCI 6-10
OCI_ATTR_MAX
attribute, OCI 6-14
OCI_ATTR_MAX_CATALOG_ NAMELEN
attribute, OCI 6-20
OCI_ATTR_MAX_COLUMN_ NAMELEN
attribute, OCI 6-19
OCI_ATTR_MAX_PROC_NAMELEN
attribute, OCI 6-19
OCI_ATTR_MAXDATA_SIZE
bind handle attribute, OCI A-21
use with binding, OCI 5-27
OCI_ATTR_MEMPOOL_APPNAME, OCI A-49
OCI_ATTR_MEMPOOL_HOMENAME, OCI A-49
OCI_ATTR_MEMPOOL_INSTNAME, OCI A-50
OCI_ATTR_MEMPOOL_SIZE, OCI A-50
OCI_ATTR_MIGSESSION
user session handle attribute, OCI A-12
OCI_ATTR_MIN
attribute, OCI 6-14
OCI_ATTR_NAME, OCI A-41, OCI A-47
attribute, OCI 6-8, OCI 6-10, OCI 6-11, OCI 6-13, OCI 6-14, OCI 6-15, OCI 6-16
OCI_ATTR_NCHARSET_ID
attribute, OCI 6-19
OCI_ATTR_NONBLOCKING_MODE
server handle attribute, OCI A-9
OCI_ATTR_NOWAIT_SUPORT
attribute, OCI 6-20
OCI_ATTR_NUM_ATTRS
attribute, OCI 6-5
OCI_ATTR_NUM_COLS, OCI A-41, OCI A-42
attribute, OCI 6-7
OCI_ATTR_NUM_DML_ERRORS, OCI A-14
OCI_ATTR_NUM_ELEMENTS
attribute, OCI 6-13
OCI_ATTR_NUM_HANDLES
attribute, OCI 6-19
OCI_ATTR_NUM_PARAMS
attribute, OCI 6-5
OCI_ATTR_NUM_ROWS, OCI A-42
OCI_ATTR_NUM_TYPE_ATTRS
attribute, OCI 6-9
OCI_ATTR_NUM_TYPE_METHODS
attribute, OCI 6-10
OCI_ATTR_OBJECT
environment handle attribute, OCI A-4
OCI_ATTR_OBJECT_DETECTCHANGE
environment handle attribute, OCI 13-13
OCI_ATTR_OBJID
attribute, OCI 6-7, OCI 6-14
OCI_ATTR_ORDER
attribute, OCI 6-15
OCI_ATTR_ORDER_METHOD
attribute, OCI 6-10
OCI_ATTR_OVERLOAD
attribute, OCI 6-8
OCI_ATTR_PARAM
describe handle attribute, OCI A-24
OCI_ATTR_PARAM_COUNT
describe handle attribute, OCI A-24
statement handle attribute, OCI A-17
OCI_ATTR_PARTITIONED
attribute, OCI 6-7
OCI_ATTR_PASSWORD
user session handle attribute, OCI A-12
OCI_ATTR_PDSCL
bind handle attribute, OCI A-21, OCI A-23
OCI_ATTR_PIN_DURATION
environment handle attribute, OCI A-4
OCI_ATTR_PINOPTION
environment handle attribute, OCI A-4
OCI_ATTR_POSITION
attribute, OCI 6-16
OCI_ATTR_PRECISION, OCI A-48
attribute, OCI 6-5, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-17
OCI_ATTR_PREFETCH_MEMORY
statement handle attribute, OCI A-18
OCI_ATTR_PREFETCH_ROWS
statement handle attribute, OCI A-18
OCI_ATTR_PROC_MODE, OCI A-50
OCI_ATTR_PTYPE
attribute, OCI 6-6
OCI_ATTR_RADIX
attribute, OCI 6-17
OCI_ATTR_REF_TDO
attribute, OCI 6-7, OCI 6-9, OCI 6-11, OCI 6-14, OCI 6-16, OCI 6-18
OCI_ATTR_ROW_COUNT, OCI A-43
OCI_ATTR_ROWID
statement handle attribute, OCI A-17
OCI_ATTR_ROWS_RETURNED
bind handle attribute, OCI A-22
use with callbacks, OCI 5-25
OCI_ATTR_SAVEPOINT_SUPPORT
attribute, OCI 6-20
OCI_ATTR_SCALE, OCI A-48
attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-17
OCI_ATTR_SCHEMA_NAME, OCI A-41
attribute, OCI 6-11, OCI 6-13, OCI 6-14, OCI 6-16, OCI 6-17
OCI_ATTR_SEQ
attributes, OCI 6-14
OCI_ATTR_SERVER
service context handle attribute, OCI A-7
OCI_ATTR_SERVER_GROUP
server handle attribute, OCI A-11
OCI_ATTR_SESSION
service context handle attribute, OCI A-7
OCI_ATTR_SHARED_HEAP_ALLOC, OCI A-6
OCI_ATTR_STMT_TYPE
statement handle attribute, OCI A-17
OCI_ATTR_STREAM_OFFSET, OCI A-44
OCI_ATTR_SUB_NAME, OCI A-42
attribute, OCI 6-18
OCI_ATTR_SUBSCR_CALLBACK, OCI A-37
OCI_ATTR_SUBSCR_CTX, OCI A-37
OCI_ATTR_SUBSCR_NAME, OCI A-38
OCI_ATTR_SUBSCR_NAMESPACE, OCI A-37
OCI_ATTR_SUBSCR_PAYLOAD, OCI A-38
OCI_ATTR_TABLESPACE
attribute, OCI 6-7
OCI_ATTR_TIMESTAMP
attribute, OCI 6-6
OCI_ATTR_TRANS
service context handle attribute, OCI A-7
OCI_ATTR_TRANS_NAME
transaction handle attribute, OCI A-13
OCI_ATTR_TYPE_NAME
attribute, OCI 6-11, OCI 6-13, OCI 6-16, OCI 6-17
OCI_ATTR_TYPECODE
attribute, OCI 6-9, OCI 6-10, OCI 6-13, OCI 6-16
OCI_ATTR_USRNAME
user session handle attribute, OCI A-12
OCI_ATTR_VERSION
attribute, OCI 6-9, OCI 6-19
OCI_ATTR_XID
transaction handle attribute, OCI A-13
OCI_EVENTS
mode for receiving notifications, OCI 9-30
OCI_LOCK_X_NOWAIT
parameter usage, OCI 13-13
OCI_NUM_SHARED_PROCS, OCI 2-22
OCI_PTYPE_ARG
attributes, OCI 6-16
OCI_PTYPE_COL
attributes, OCI 6-15
OCI_PTYPE_COLL
attributes, OCI 6-13
OCI_PTYPE_DATABASE
attributes, OCI 6-19
OCI_PTYPE_FUNC
attributes, OCI 6-8
OCI_PTYPE_LIST
attributes, OCI 6-18
OCI_PTYPE_PKG
attributes, OCI 6-8
OCI_PTYPE_PROC
attributes, OCI 6-8
OCI_PTYPE_SCHEMA
attributes, OCI 6-19
OCI_PTYPE_SYN
attributes, OCI 6-14
OCI_PTYPE_TABLE
attributes, OCI 6-7
OCI_PTYPE_TYPE
attributes, OCI 6-9
OCI_PTYPE_TYPE_ATTR
attributes, OCI 6-10
OCI_PTYPE_TYPE_FUNC
attributes, OCI 6-11
OCI_PTYPE_TYPE_PROC
attributes, OCI 6-11
OCI_PTYPE_VIEW
attributes, OCI 6-7
OCI_SHARED_MODE, OCI 2-21
OCI_TYPECODE
values, OCI 3-23, OCI 3-24, OCI 3-25
OCIAQAgent
descriptor attributes, OCI A-35
OCIAQDeq(), OCI 15-5
OCIAQDeqOptions
descriptor attributes, OCI A-28
OCIAQEnq(), OCI 15-7
OCIAQEnqOptions
descriptor attributes, OCI A-26
OCIAQListen(), OCI 15-19
OCIAQMsgProperties
descriptor attributes, OCI A-31
OCIArray, OCI 11-17
binding and defining, OCI 11-17, OCI 12-6
OCIArray manipulation
code example, OCI 11-19
OCIAttrGet(), OCI 15-28
used for describing, OCI 4-11
OCIAttrSet(), OCI 15-29
OCIBindArrayOfStruct(), OCI 15-43
OCIBindByName(), OCI 15-44
OCIBindByPos(), OCI 15-48
OCIBindDynamic(), OCI 15-52
OCIBindObject(), OCI 15-56
OCIBreak(), OCI 15-216
use of, OCI 2-33, OCI 2-37
OCICacheFlush(), OCI 16-9
OCICacheFree(), OCI 16-48
OCICacheRefresh(), OCI 16-11
OCICacheUnmark(), OCI 16-17
OCICacheUnpin(), OCI 16-49
OCIColl, OCI 11-17
binding and defining, OCI 11-17
OCICollAppend(), OCI 17-6
OCICollAssign(), OCI 17-7
OCICollAssignElem(), OCI 17-8
OCICollGetElem(), OCI 17-10
OCICollIsLocator(), OCI 17-13
OCICollMax(), OCI 17-14
OCICollSetUpdateStatus(), OCI 17-15
OCICollSize(), OCI 17-16
OCICollTrim(), OCI 17-18
OCIComplexObject
use of, OCI 10-23
OCIComplexObjectComp
use of, OCI 10-23
OCIDate, OCI 11-7, PC_ 17-34
binding and defining, OCI 11-7, OCI 12-6
declaring, PC_ 17-34
OCIDate manipulation
code example, OCI 11-8
OCIDateAddDays(), OCI 17-28
OCIDateAddMonths(), OCI 17-29
OCIDateAssign(), OCI 17-30
OCIDateCheck(), OCI 17-31
OCIDateCompare(), OCI 17-33
OCIDateDaysBetween(), OCI 17-34
OCIDateFromText(), OCI 17-35
OCIDateGetDat(), OCI 17-37
OCIDateGetTime(), OCI 17-38
OCIDateLastDay(), OCI 17-39
OCIDateNextDay(), OCI 17-40
OCIDateSetDate(), OCI 17-41
OCIDateSetTime(), OCI 17-42
OCIDateSysDate(), OCI 17-43
OCIDateToText(), OCI 17-44
OCIDateZoneToZone(), OCI 17-46
OCIDefineArrayOfStruct(), OCI 15-58
OCIDefineByPos(), OCI 15-59
OCIDefineDynamic(), OCI 15-63
OCIDefineObject(), OCI 15-65
OCIDescAlloc(), OCI 15-31
OCIDescFree(), OCI 15-33
OCIDescribeAny(), OCI 15-67
usage examples, OCI 6-20
using, OCI 6-2
ocidfn.h, PC_ 5-50
OCIDirPathAbort(), OCI 15-73
OCIDirPathColArrayEntryGet(), OCI 15-74
OCIDirPathColArrayEntrySet(), OCI 15-76
OCIDirPathColArrayReset(), OCI 15-79
OCIDirPathColArrayRowGet(), OCI 15-78
OCIDirPathColArrayToStream(), OCI 15-80
OCIDirPathFinish(), OCI 15-82
OCIDirPathFlushRow(), OCI 15-83
OCIDirPathPrepare(), OCI 15-85
OCIDirPathStreamLoad(), OCI 15-83
OCIDirPathStreamReset(), OCI 15-86
OCIDuration
use of, OCI 13-7, OCI 13-14
OCIDurationBegin(), OCI 15-109
OCIDurationEnd(), OCI 15-110
OCIEnvCallback, OCI 9-15
OCIEnvCreate(), OCI 15-88
OCIEnvInit(), OCI 15-91
OCIErrorGet(), OCI 15-217
OCIExtProcAllocCallmemory(), DCI 13-2, DCI 13-3, DCI 13-4, OCI 18-5
OCIExtProcAllocMemory routine, DCI 4-12
OCIExtProcGetEnv(), OCI 18-8
OCIExtProcRaiseExcp routine, DCI 4-13
OCIExtProcRaiseExcp(), DCI 13-3, OCI 18-6
OCIExtProcRaiseExcpWithMsg routine, DCI 4-13
OCIExtProcRaiseExcpWithMsg(), DCI 13-4, OCI 18-7
OCIHandleAlloc(), OCI 15-34
OCIHandleFree(), OCI 15-37
OCIInd
use of, OCI 10-29
OCIInitialize(), OCI 15-93
shared mode, OCI 2-20
OCIIter, OCI 11-17
binding and defining, OCI 11-17
usage example, OCI 11-19
OCIIterCreate(), OCI 17-19
OCIIterDelete(), OCI 17-20
OCIIterGetCurrent(), OCI 17-21
OCIIterInit(), OCI 17-22
OCIIterNext(), OCI 17-23
OCIIterPrev(), OCI 17-25
OCILdaToSvcCtx(), OCI 15-219
OCILob...() functions, DCI 6-6
OCILobAppend(), OCI 15-111
OCILobAssign(), OCI 15-112
OCILobCharSet(), OCI 15-114, OCI 15-115
OCILobClose(), OCI 15-116
OCILobCopy(), OCI 15-117
OCILobCreateTemporary(), OCI 15-119
OCILobDisableBuffering(), OCI 15-121
OCILobEnableBuffering(), OCI 15-122
OCILobErase(), OCI 15-123
OCILobFileClose(), OCI 15-124
OCILobFileCloseAll(), OCI 15-125
OCILobFileExists(), OCI 15-126
OCILobFileIsOpen(), OCI 15-129
OCILobFileOpen(), OCI 15-130
OCILobFlushBuffer(), OCI 15-132
OCILobFreeTemporary(), OCI 15-134
OCILobGetChunkSize(), OCI 15-135
OCILobGetFileName(), OCI 15-127
OCILobGetLength(), OCI 15-137
OCILobIsEqual(), OCI 15-138
OCILobIsOpen(), OCI 15-139
OCILobIsTemporary(), OCI 15-141
OCILobLoadFromFile(), OCI 15-142
OCILobLocatorAssign(), OCI 15-144
OCILobLocatorIsInit(), OCI 15-146
OCILobOpen(), OCI 15-147
OCILobRead(), OCI 15-148
OCILobSetFileName(), OCI 15-131
OCILobTrim(), OCI 15-152
OCILobWrite(), OCI 15-153
OCILobWriteAppend(), OCI 15-157
OCILockOpt
possible values, OCI 16-28, OCI 16-54
OCILogoff(), OCI 15-96
OCILogon(), OCI 15-97
using, OCI 2-23
OCINumber, OCI 11-10, PC_ 17-34
bind example, OCI 12-8
binding and defining, OCI 11-10, OCI 12-6
declaring, PC_ 17-34
define example, OCI 12-8
OCINumber manipulation
code example, OCI 10-13, OCI 11-13
OCINumberAbs(), OCI 17-50
OCINumberAdd(), OCI 17-51
OCINumberArcCos(), OCI 17-52
OCINumberArcSin(), OCI 17-53
OCINumberArcTan(), OCI 17-54
OCINumberArcTan2(), OCI 17-55
OCINumberAssign(), OCI 17-56
OCINumberCeil(), OCI 17-57
OCINumberCompare(), OCI 17-58
OCINumberCos(), OCI 17-59
OCINumberDec(), OCI 17-60
OCINumberDiv(), OCI 17-61
OCINumberExp(), OCI 17-62
OCINumberFloor(), OCI 17-63
OCINumberFromInt(), OCI 17-64
OCINumberFromReal(), OCI 17-65
OCINumberFromText(), OCI 17-66
OCINumberHypCos(), OCI 17-68
OCINumberHypSin(), OCI 17-69
OCINumberHypTan(), OCI 17-70
OCINumberInc(), OCI 17-71
OCINumberIntPower(), OCI 17-72
OCINumberIsInt(), OCI 17-73
OCINumberIsZero(), OCI 17-74
OCINumberLn(), OCI 17-75
OCINumberLog(), OCI 17-76
OCINumberMod(), OCI 17-77
OCINumberMul(), OCI 17-78
OCINumberNeg(), OCI 17-79
OCINumberPower(), OCI 17-80
OCINumberPrec(), OCI 17-81
OCINumberRound(), OCI 17-82
OCINumberSetPi(), OCI 17-83
OCINumberSetZero(), OCI 17-84
OCINumberShift(), OCI 17-85
OCINumberSign(), OCI 17-86
OCINumberSin(), OCI 17-87
OCINumberSqrt(), OCI 17-88
OCINumberSub(), OCI 17-89
OCINumberTan(), OCI 17-90
OCINumberToInt(), OCI 17-91
OCINumberToReal(), OCI 17-92
OCINumberToText(), OCI 17-93
OCINumberTrunc(), OCI 17-95
OCIObjectArrayPin(), OCI 16-50
OCIObjectCopy(), OCI 16-33
OCIObjectExists(), OCI 16-25
OCIObjectFlush(), OCI 16-13
OCIObjectFree(), OCI 16-52
OCIObjectGetAttr(), OCI 16-35
OCIObjectGetInd(), OCI 16-37
OCIObjectGetObjectRef(), OCI 16-38
OCIObjectGetTypeRef(), OCI 16-39
OCIObjectIsDirty(), OCI 16-30
OCIObjectIsLocked(), OCI 16-31
OCIObjectLifetime
possible values, OCI 16-27
OCIObjectLock(), OCI 16-40
OCIObjectLockNoWait(), OCI 16-41
OCIObjectMarkDelete(), OCI 16-18
OCIObjectMarkDeleteByRef(), OCI 16-19
OCIObjectMarkStatus
possible values, OCI 16-28
OCIObjectMarkUpdate(), OCI 16-20
OCIObjectNew(), OCI 16-42
OCIObjectPin(), OCI 16-54
OCIObjectPinCountReset(), OCI 16-57
OCIObjectPinTable(), OCI 16-58
OCIObjectRefresh(), OCI 16-14
OCIObjectSetAttr(), OCI 16-45
OCIObjectUnmark(), OCI 16-22
OCIObjectUnmarkByRef(), OCI 16-23
OCIObjectUnpin(), OCI 16-60
OCIParamGet(), OCI 15-39
used for describing, OCI 4-11
OCIParamSet(), OCI 15-41
OCIPasswordChange(), OCI 15-220
OCIPinOpt
use of, OCI 13-7
OCIRaw, OCI 11-16, PC_ 17-34
binding and defining, OCI 11-16, OCI 12-6
declaring, PC_ 17-34
OCIRaw manipulation
code example, OCI 11-17
OCIRawAllocSize(), OCI 17-97
OCIRawAssignBytes(), OCI 17-98
OCIRawAssignRaw(), OCI 17-99
OCIRawPtr(), OCI 17-100
OCIRawResize(), OCI 17-101
OCIRawSize(), OCI 17-102
OCIRef, OCI 11-22
binding and defining, OCI 11-22
usage example, OCI 11-22
OCIRefAssign(), OCI 17-104
OCIRefClear(), OCI 17-105
OCIRefFromHex(), OCI 17-106
OCIRefHexSize(), OCI 17-107
OCIRefIsEqual(), OCI 17-108
OCIRefIsNull(), OCI 17-109
OCIRefToHex(), OCI 17-110
OCIReset(), OCI 15-222
use of, OCI 2-37
OCIRowid, OCI 2-16
OCIServerAttach(), OCI 15-99
shadow processes, OCI 15-100
OCIServerDetach(), OCI 15-101
OCIServerVersion(), OCI 15-223
OCISessionBegin(), OCI 15-102
OCISessionEnd(), OCI 15-105
OCIStmtExecute(), OCI 15-161
prefetch during, OCI 4-6
use of iters parameter, OCI 4-6
OCIStmtFetch, STU 25-24
OCIStmtFetch(), OCI 15-164
OCIStmtGetBind(), OCI 15-70
OCIStmtGetPieceInfo(), OCI 15-165
OCIStmtPrepare(), OCI 15-167
preparing SQL statements, OCI 4-4
shared mode, OCI 2-21
OCIStmtSetPieceInfo(), OCI 15-169
OCIString, OCI 11-15, PC_ 17-34
binding and defining, OCI 11-15, OCI 12-6
declaring, PC_ 17-34
OCIString manipulation
code example, OCI 11-15
OCIStringAllocSize(), OCI 17-112
OCIStringAssign(), OCI 17-113
OCIStringAssignText(), OCI 17-114
OCIStringPtr(), OCI 17-115
OCIStringResize(), OCI 17-116
OCIStringSize(), OCI 17-117
OCISubscriptionDisable(), OCI 15-20
OCISubscriptionEnable(), OCI 15-21
OCISubscriptionPost(), OCI 15-22
OCISubscriptionRegister(), OCI 15-24
OCISubscriptionUnRegister(), OCI 15-26
OCISvcCtxToLda(), OCI 15-224
OCITable, OCI 11-17
binding and defining, OCI 11-17, OCI 12-6
OCITableDelete(), OCI 17-119
OCITableExists(), OCI 17-120
OCITableFirst(), OCI 17-121
OCITableLast(), OCI 17-122
OCITableNext(), OCI 17-123
OCITablePrev(), OCI 17-124
OCITableSize(), OCI 17-125
OCITerminate(), OCI 15-106
OCIThreadClose(), OCI 15-173
OCIThreadCreate(), OCI 15-174
OCIThreadHandleGet(), OCI 15-176
OCIThreadHndDestroy(), OCI 15-177
OCIThreadHndInit(), OCI 15-178
OCIThreadIdDestroy(), OCI 15-179
OCIThreadIdGet(), OCI 15-180
OCIThreadIdInit(), OCI 15-181
OCIThreadIdNull(), OCI 15-182
OCIThreadIdSame(), OCI 15-183
OCIThreadIdSet(), OCI 15-184
OCIThreadIdSetNull(), OCI 15-185
OCIThreadInit(), OCI 15-186
OCIThreadIsMulti(), OCI 15-187
OCIThreadJoin(), OCI 15-188
OCIThreadKeyDestroy(), OCI 15-189
OCIThreadKeyGet(), OCI 15-190
OCIThreadKeyInit(), OCI 15-191
OCIThreadKeySet(), OCI 15-192
OCIThreadMutexAcquire(), OCI 15-193
OCIThreadMutexDestroy(), OCI 15-194
OCIThreadMutexInit(), OCI 15-195
OCIThreadMutexRelease(), OCI 15-196
OCIThreadProcessInit(), OCI 15-197
OCIThreadTerm(), OCI 15-198
OCITransCommit(), OCI 15-200
OCITransDetach(), OCI 15-203
OCITransForget(), OCI 15-204
OCITransPrepare(), OCI 15-205
OCITransRollback, STU 25-24
OCITransRollback(), OCI 15-206
OCITransStart(), OCI 15-207
OCIType
description, OCI 11-23
OCITypeArrayByName(), OCI 16-63
OCITypeArrayByRef(), OCI 16-66
OCITypeByName(), OCI 16-68
OCITypeByRef(), OCI 16-70
OCITypeElem
description, OCI 11-23
OCITypeMethod
description, OCI 11-23
OCIUserCallbackGet(), OCI 15-225
OCIUserCallbackRegister(), OCI 15-227
ODCIGetInterfaces method, DCI 11-25
ODCIIndex, SCN 10-43
ODCIIndexClose method, DCI 11-33
ODCIIndexCreate method, DCI 11-25
ODCIIndexDelete method, DCI 11-34
ODCIIndexDrop method, DCI 11-27
ODCIIndexFetch method, DCI 11-32
ODCIIndexGetMetadata method, DCI 11-37
ODCIIndexInsert method, DCI 11-33
ODCIIndexStart method, DCI 11-28, DCI 11-30
ODCIIndexUpdate method, DCI 11-35
ODESSP function
information about stored subprograms, PCO 6-31
OEM_REPOSITORY tablespace raw device, PSC 2-6
oemapp console command, PSC 5-15
oemctrl start oms command, PSC 5-14
OF clause
of CREATE VIEW, SQL 7-432
OF object_type clause
of CREATE TABLE, SQL 7-367
OFA, MIG 1-5
offline
backups, SBR 3-18
taking standby database datafiles, SBR 16-27
offline backup, SPS 4-6, SPS 21-1
parallel, SPS 21-12
redo log files, SPS 21-12
offline backups
whole database backup, SCN 32-23
Offline Bitmapped Tablespaces, SUT 1-55
OFFLINE clause
of ALTER ROLLBACK SEGMENT, SQL 7-74
of ALTER TABLESPACE, SQL 7-168