Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
R
S
T
U
V
W
X
A
- accessing external LOBs, 12-5
- ALTER TABLE
- migrating from LONG to LOB, 8-3
- amount, 12-56
- amount parameter
- reading and loading LOB data, the size of (FAQ), 6-5
- used with BFILEs, 12-38
- ANSI standard for LOBs, 11-10
- AppendChunk(), see OraOLEDB, 13-3
- appending
- one LOB to another
- internal persistent LOBs, 10-82
- one temporary LOB to another, 11-51
- writing to the end of a LOB
- internal persistent LOBs, 10-85
- assigning
- one collection to another collection in temporary LOBs, 11-11
- one temporary LOB to another, 11-11
B
- BFILENAME(), 12-24, 12-84
- advantages of using, 12-7
- BFILEs
- accessing, 12-5
- closing, 12-91
- converting to CLOB or NCLOB, 12-38
- creating an object in object cache, 5-18
- datatype, 2-2, 2-3
- equal locators, check for, 12-77
- initializing using BFILENAME(), 2-7
- locators, 2-6
- maximum number of open, 4-2, 12-70
- multi-threaded server (MTS), 12-11
- Oracle Objects for OLE (OO4O)
- opening/closing methods, 3-41
- properties, 3-42
- read-only methods, 3-42
- reference semantics, 2-3
- security, 12-8
- storage devices, 2-2
- binding data to internal LOBs, restriction removal, 4-17
- binds
- HEX to RAW or RAW to HEX conversion, 7-15
- updating more than 4,000 bytes
- internal persistent LOBs, 10-111
- See also INSERT statements and UPDATE statements
- BLOBs
- datatype, 2-2
- buffering
- disable
- internal persistent LOBs, 10-106
- enable
- internal persistent LOBs, 10-100
- flush
- internal persistent LOBs, 10-103
- LOB buffering subsystem, 5-22
C
- C++, See Pro*C/C++ precompiler
- C, See OCI
- CACHE / NOCACHE, 7-8
- caches
- object cache, 5-18
- callback, 10-47, 10-50, 10-57, 10-86, 11-56
- catalog views
- v$temporary_lobs, 11-12
- CHAR buffer, defining on CLOB, 7-40
- CHAR to CLOB
- SQL and PL/SQL conversion, 7-35
- character data
- varying width, 2-4
- character set form
- getting
- internal persistent LOBs, 10-80
- character set ID
- getting the
- internal persistent LOBs, 10-78
- temporary LOB of, getting the, 11-47
- charactersets
- multibyte,LONGs and LOBs, 8-5
- checking in a LOB
- internal persistent LOBs, 10-49
- checking out a LOB
- internal persistent LOBs, 10-46
- CHUNK, 7-10
- chunks
- when to use, 6-28
- chunksize, 10-89
- multiple of, to improve performance, 10-58
- classes
- putChars(), 6-12
- CLOBs
- columns
- varying- width character data, 2-4
- datatype, 2-2
- varying-width columns, 2-4
- varying-width, 2-4
- Clone method, See Oracle Objects for OLE (OO4O)
- closing
- all open BFILEs, 12-97
- BFILEs, 12-91
- BFILEs with CLOSE, 12-95
- BFILEs with FILECLOSE, 12-93
- clustered tables, 8-10
- COBOL, See Pro*COBOL precompiler
- code
- example programs, 1-8
- list of demonstration programs, 1-8
- comparing
- all or part of two LOBs
- internal persistent LOBs, 10-63
- all or part of two temporary LOBs, 11-33
- all or parts of two BFILEs, 12-62
- compatibility, 1-9
- conventional path load, 9-3
- conversion
- explicit functions for PL/SQL, 7-48
- conversions
- character set, 12-38
- character set conversions needed on BFILE before using LOADFROMFILE(), 11-21
- from binary data to character set, 12-38
- implicit, between CLOB and VARCHAR2, 7-46
- See also binds HEX to RAW
- conversions,implicit between CLOBs and CHAR, 7-36
- converting
- between different LOB types, 6-26
- to CLOB, 7-48
- converting to LOB data types, 6-4
- copy semantics, 2-3
- internal LOBs, 10-26
- copying
- all or part of a LOB to another LOB
- internal persistent LOBs, 10-69
- all or part of one temporary LOB to another, 11-39
- for BFILEs there is no copy function, 12-86
- LOB locator
- internal persistent LOBs, 10-72
- LOB locator for BFILE, 12-73
- LONG to LOB, 10-37
- LONG to LOB (FAQ), 6-4
- temporary LOB locator, 11-41
- TO_LOB limitations, 10-42
- crashing
- Is LOB data lost after (FAQ), 6-7
- creating a temporary LOB, 11-14
- creating tables
- containing an object type with LOB attribute
- internal Persistent LOBs, 10-13
- containing BFILEs, 12-14
- containing one or more LOB columns
- internal persistent LOBs, 10-8
- containing one ore more BFILE columns, 12-15
- nested, containing LOB
- internal persistent LOBs, 10-18
- of an object type with BFILE attribute, 12-18
- with a nested table containing a BFILE, 12-21
- creating VARRAYs
- containing references to LOBs, 5-29
D
- datatypes
- converting to LOBs FAQ, 6-4
- DBMS_LOB
- ERASE, 6-12
- substr vs. read, 6-28
- updating LOB with bind variable, 5-10
- WRITE()
- passing hexadecimal string to, 10-90
- DBMS_LOB package
- available LOB procedures/functions, 3-3, 3-4
- .createTemporary() as JDBC workaround, 11-12
- isTemporary() as JDBC workaround, 11-12
- LOADFROMFILE(), 12-38
- multi-threaded server (MTS), 12-11
- WRITE()
- guidelines, 10-90
- guidelines for temporary LOBs, 11-56
- passing hexadecimal string to, 11-56
- DBMS_LOB()
- READ, 10-57
- DBMS_LOB.createtemporary(), 11-7
- DBMS_LOB.READ, 12-56
- DELETE
- BLOB columns versus BFILE columns, and LOB indexing, 6-18
- deleting
- row containing LOB
- internal persistent LOBs, 10-118
- demonstration programs, 1-8
- directories
- catalog views, 12-10
- guidelines for usage, 12-10
- ownership and privileges, 12-8
- DIRECTORY name specification, 12-8
- DIRECTORY object, 12-5
- catalog views, 12-10
- getting the alias and filename, 12-79
- guidelines for usage, 12-10
- names on WindowsNT, 12-8
- naming convention, 12-8
- OS file must exist before locator use, and, 12-25
- READ permission on object not individual files, 12-9
- directory objects, 12-5
- directory_alias parameter, 12-26
- direct-path load, 9-3
- disable buffering, See LOB buffering
- DISABLE STORAGE IN ROW, 6-23
- when to use, 6-21
- disk striping of LOB files, B-3
- displaying
- LOB data for internal persistent LOBs, 10-53
- temporary LOB data, 11-26
E
- EMPTY_BLOB()
- setdata using JPublisher (FAQ), 6-10
- EMPTY_BLOB()/EMPTY_CLOB()
- when to use (FAQ), 6-8
- EMPTY_CLOB()
- LOB locator storage, 6-22
- EMPTY_CLOB()/BLOB()
- to initialize a BFILE, 2-7
- to initialize internal LOB
- equal
- one LOB locator to another
- internal persistent LOBs, 10-74
- one temporary LOB locator, to another, 11-43
- equal locators
- checking if one BFILE LOB locator equals another, 12-77
- erasing
- part of LOB
- internal persistent LOBs, 10-97
- part of temporary LOBs, 11-60
- errors
- ORA-03127, 6-13
- examples
- demonstration programs, 1-8
- read consistent locators, 5-3
- repercussions of mixing SQL DML with DBMS_LOB, 5-6
- updated LOB locators, 5-8
- updating a LOB with a PL/SQL variable, 5-10
- existance
- check for BFILE, 12-67
- extensible indexes, 7-32
- external callout, 5-24
- external LOBs (BFILEs)
- See BFILEs
- external LOBs (BFILEs), See BFILEs
F
- FILECLOSEALL(), 12-11, 12-41, 12-47
- flushing
- LOB buffer, 5-23
- flushing buffer, 5-19
- temporary LOB, 11-64
- FOR UPDATE clause
- LOB locator, 5-2
- LOBs, 2-8
- freeing
- temporary LOBs, 11-18
- FREETEMPORARY(), 11-18
- freeTemporary() as JDBC workaround, 11-12
- functional indexes, 7-32
- function-based indexing, 1-8
G
- GetChunk(), see OraOLEDB, 13-3
H
- hexadecimal string
- passing to DBMS_LOB.WRITE(), 10-90, 11-56
I
- implicit conversions, 7-36
- indexes
- function-based, 1-8
- rebuilding after LONG-to-LOB migration, 8-9
- index-organized tables
- inline storage for LOBs and (FAQ), 6-7
- initialized
- checking if BFILE LOB locator is, 12-75
- initializing
- BFILE column or locator variable using BFILENAME(), 12-25
- BLOB attribute using EMPTY_BLOB() FAQ, 6-9
- BLOB attribute with EMPTY_BLOB() in Java (FAQ), 6-9
- during CREATE TABLE or INSERT, 10-24
- external LOBs, 2-7
- internal LOBs, See LOBs
- internal LOBs
- using EMPTY_CLOB(), EMPTY_BLOB()
- inline
- when to use, 6-29
- INSERT statements
- binds of greater than 4000 bytes, 7-14
- inserting
- a row by initializing a LOB locator
- internal persistent LOBs, 10-28
- a row by initializing BFILE locator, 12-30
- a row by selecting a LOB from another table
- internal persistent LOBs, 10-26
- a row containing a BFILE, 12-23
- a row containing a BFILE by selecting BFILE from another table, 12-28
- a row using BFILENAME(), 12-24
- any length data (FAQ), 6-4
- binds of more than 4,000 bytes, 10-22
- LOB value using EMPTY_CLOB()/EMPTY_BLOB()
- internal persistent LOBs, 10-23
- one or more LOB values into a row, 10-21
- row with empty LOB using JDBS (FAQ), 6-9
- interfaces for LOBs, see programmatic environments
J
- Java, See JDBC
- JDBC
- available LOB methods/properties, 3-4
- driver to load LOBs, improving performance, 6-15
- inserting a row with empty LOB locator into table, 6-9
- now binds and defines VARCHAR2 variables, 7-52
- temporary LOB workarounds not needed, 11-12
- JPublisher
- building an empty LOB in, 6-10
L
- LBS, See Lob Buffering Subsystem (LBS)
- length
- an internal persistent LOB, 10-67
- getting BFILE, 12-70
- temporary LOB, 11-37
- LOADFROMFILE()
- BFILE character set conversions needed before using, 11-21
- loading
- 1Mb into CLOB column, FAQ, 6-15
- a LOB with BFILE data, 12-37
- data into internal LOB, 10-30
- external LOB (BFILE) data into table, 12-33
- LOB with data from a BFILE, 10-32
- temporary LOB with data from BFILE, 11-20
- loading XML documents, 9-2
- LOB, 5-13
- LOB buffering
- buffer-enabled locators, 5-25
- disable for temporaryLOBs, 11-66
- example, 5-22
- flushing for temporary LOBs, 11-64
- flushing the buffer, 5-23
- flushing the updated LOB through LBS, 5-24
- guidelines, 5-19
- OCI example, 5-26
- OCILobFlushBuffer(), 5-24
- Oracle Objects for OLE (OO4O)
- methods for internal LOBs, 3-42
- physical structure of buffer, 5-21
- temporary LOBs
- CACHE, NOCACHE, CACHE READS, 11-8
- usage notes, 5-21
- LOB Buffering SubSystem (LBS)
- LOB Buffering Subsystem (LBS)
- advantages, 5-19
- buffer-enabled locators, 5-24
- buffering example using OCI, 5-26
- example, 5-22
- flushing
- updated LOB, 5-24
- flushing the buffer, 5-23
- guidelines, 5-19
- saving the state of locator to avoid reselect, 5-25
- usage, 5-21
- LOB locator
- copy semantics, 2-3
- external LOBs (BFILEs), 2-3
- internal LOBs, 2-3
- reference semantics, 2-3
- LOB-Based web site,building, 14-12
- LOBFILE, syntax, 9-2
- LOBs, 5-18
- accessing through a locator, 2-8
- attributes and object cache, 5-18
- buffering
- caveats, 5-19
- pages can be aged out, 5-24
- buffering subsystem, 5-19
- buffering usage notes, 5-21
- CACHE READS setting, 4-17
- compatibility, 1-9
- datatypes versus LONG, 1-4
- external (BFILEs), 2-2
- flushing, 5-19
- in partitioned tables, 7-26
- in the object cache, 5-18
- index metadata through system views, 6-19
- inline storage, 2-6
- interfaces, See programmatic environments
- interMEDIA, 1-4
- internal
- creating an object in object cache, 5-18
- internal LOBs
- CACHE / NOCACHE, 7-8
- CHUNK, 7-10
- copy semantics, 2-3
- ENABLE | DISABLE STORAGE IN ROW, 7-11
- initializing, 12-55
- locators, 2-6
- locking before updating, 10-70, 10-83, 10-86, 10-89, 10-94, 10-98
- LOGGING / NOLOGGING, 7-9
- Oracle Objects for OLE (OO4O), modifying methods, 3-40
- PCTVERSION, 7-7
- setting to empty, 2-10
- tablespace and LOB index, 7-7
- tablespace and storage characteristics, 7-5
- transactions, 2-2
- locators, 2-6, 5-2
- cannot span transactions, 7-14
- migration issues, 1-9
- object cache, 5-18
- performing SELECT on, 2-8
- piecewise operations, 5-6
- read consistent locators, 5-2
- reason for using, 1-2
- setting to contain a locator, 2-6
- setting to NULL, 2-9
- tables
- adding partitions, 7-31
- creating, 7-28
- creating indexes, 7-30
- exchanging partitions, 7-31
- merging partitions, 7-32
- moving partitions, 7-31
- partitioning, 7-28
- splitting partitions, 7-31
- typical uses, B-2
- unstructured data, 1-2
- updated LOB locators, 5-6
- value, 2-6
- varying-width character data, 7-3
- locators, 2-6
- accessing a LOB through, 2-8
- BFILEs, 12-12
- guidelines, 12-12
- two rows can refer to the same file, 12-12
- buffer-enabled, 5-25
- cannot span transactions, 7-14
- copying temporary LOB, 11-41
- external LOBs (BFILEs), 2-6
- initializing LOB or BFILE to contain, 2-7
- LOB, cannot span transactions, 5-13
- multiple, 5-3
- read consistent, 5-2, 5-3, 5-11, 5-13, 5-24, 5-26, 5-27, 5-28
- read consistent locators, 5-2
- read consistent locators provide same LOB value regardless when SELECT occurs, 5-3
- read consistent,updating, 5-2
- reading and writing to a LOB using, 5-15
- saving the state to avoid reselect, 5-25
- see if LOB locator is initialized
- internal persistent LOBs, 10-76
- selecting, 2-8
- selecting within a transaction, 5-17
- selecting without current transacation, 5-16
- setting column or attribute to contain, 2-6
- temporary, SELECT permanent LOB INTO, 11-9
- transaction boundaries, 5-15
- updated, 5-6, 5-10, 5-23
- updating, 5-13
- LOGGING
- migrating LONG-to-LOBs, 8-10
- LOGGING / NOLOGGING, 7-9
- LONG API
- See LONG-to-LOB, 8-2
- LONG versus LOB datatypes, 1-4
- LONG-to-LOB Migration, 8-2
- LONG-to-LOB migration
- ALTER TABLE, 8-6
- changes needed, 8-23
- clustered tables, 8-10
- examples, 8-25
- LOGGING, 8-10
- Multibyte Charactersets, 8-5
- NULLs, 8-12
- OCI, 8-3, 8-13
- parameter passing, 8-6
- performance, 8-43
- PL/SQL, 8-5
- rebuilding indexes, 8-9
- replication, 8-10
- space requirements, 8-10
- triggers, 8-11
- utldtree.sql use for PL/SQL, 8-24
- lONG-to-LOB migration
- PL/SQL, 8-17
M
- migrating
- LONG to LOBs, 6-25
- LONG to LOBs, see LONG-to-LOB, 8-2
- LONG-to-LOB using ALTER TABLE, 8-6
- LONG-to-LOBs, constraints maintained, 8-8
- LONG-to-LOBs, indexing, 8-9
- migration, 1-9
- multi-threaded server (MTS)
- BFILEs, 12-11
N
- national language support
- NCLOBs, 2-2
- NCLOBs
- datatype, 2-2
- varying-width, 2-4
- NOCOPY restrictions, 11-12
- NOCOPY, using to pass temporary LOB parameters by reference, 9-7
- non-NULL
- before writing to LOB column make it
- internal persistent LOBs, 10-111
- IS, 7-43
- VARCHAR2
- and CLOBs, IS, 7-43
- NULL, 7-43
- null
- versus zero length, in SQL92 standard, 7-44
- NULL in, 7-43
O
- object cache, 5-18
- creating an object in, 5-18
- LOBs, 5-18
- OCCI
- compared to other interfaces, 3-3
- OCI
- available LOB functions, 3-3
- LOB buffering example, 5-26
- locators, 2-8
- now binds and defines VARCHAR2 variables with LOBs, 7-52
- temporary lobs can be grouped into logical buckets, 11-8
- using in LONG-to-LOB migration, 8-13
- using to work LOBs, 3-10
- OCIBindByName(), 7-14
- OCIBindByPos(), 7-14
- OCIDuration(), 11-8
- OCIDurationEnd(), 11-8, 11-18
- OCILobAssign(), 5-21, 11-10
- OCILobFileSetName(), 12-7, 12-12
- OCILobFlushBuffer(), 5-24
- OCILOBFreeTemporary(), 11-18
- OCILobGetLength(), 12-56
- OCILobLoadFromFile(), 12-38
- OCILobRead
- BFILEs, 12-56
- OCILobRead(), 10-54, 10-57, 11-29, 12-56
- amount, 6-7
- to read large amounts of LOB data, 10-47
- OCILobWrite(), 11-56
- to write large amounts of LOB data, 10-50
- OCILobWriteAppend(), 10-86
- OCIObjectFlush(), 12-12
- OCIObjectNew(), 12-12
- OCISetAttr(), 12-13
- OLEDB, 3-15, 13-2
- OO4O, See Oracle Objects for OLE (OO4O)
- open
- checking for open BFILEs, 12-46
- checking for open BFILEs with FILEISOPEN(), 12-48
- checking if BFILE is open with ISOPEN, 12-50
- checking if temporary LOB is, 11-24
- seeing if a LOB is open, 10-35
- opening
- BFILEs, 12-40
- BFILEs using FILEOPEN, 12-42
- BFILEs with OPEN, 12-44
- OraBfile, See Oracle Objects for OLE (OO4O)
- OraBlob, See Oracle Objects for OLE (OO4O)
- Oracle Call Interface, See OCI
- Oracle Objects for OLE (OO4O)
- available LOB methods/properties, 3-4
- internal LOB buffering, 3-37
- modifying internal LOBs, 3-51
- opening/closing external LOBs (BFILEs), 3-54
- OraBfile example
- OraBlob example
- OraBlob, OraClob, and OraBfile encapsulate locators, 3-37
- properties for operating on external LOBs (BFILEs), 3-42
- properties for operating on LOBs, 3-42
- reading/examining internal LOB and external LOB (BFile) values, 3-41
- read-only methods for external LOBs (BFILEs), 3-42
- syntax reference, 3-36
- using Clone method to retain locator independent of dynaset, 3-37
- Oracle Provider for OLEDB, see OraOLEDB, 13-2
- ORaOLEDB
- AppendChunk(), 13-3
- OraOLEDB, 3-15, 13-1, 13-2
- GetChunk(), 13-3
P
- partitioned index-organized tables
- for LOBs, 5-30
- restrictions for LOBs, 5-31
- pattern
- check if it exists in BFILE using instr, 12-65
- see if it exists IN LOB using (instr)
- internal persistent LOBs, 10-65
- temporary LOBs
- checking if it exists, 11-35
- PCTVERSION, 7-7
- performance
- assigning multiple locators to same temporary LOB, impacts, 11-10
- chunks versus reading, 6-28
- creating temporary LOBs in called routine (FAQ), 6-30
- guidelines (FAQ), 6-28
- improving BLOB and CLOB, when loading with JDBC driver, 6-15
- improving loading, when using Veritas, 6-26
- inlining and when its a good idea to use (FAQ), 6-29
- LONG-to-LOB migration, 8-43
- when using SQL semantics with LOBs, 7-44
- PIOTssee partitioned index-organized tables
- PL/SQ
- inserting Word document into a BLOB, 14-5
- PL/SQL, 3-2
- and LOBs, semantics changes, 7-45
- changing locator-data linkage, 7-49
- CLOB variables in, 7-49
- CLOB variables in PL/SQL, 7-49
- CLOB versus VARCHAR2 comparison, 7-51
- CLOBs passed in like VARCHAR2s, 7-48
- defining a CLOB Variable on a VARCHAR, 7-47
- freeing temporary LOBs automatically and manually, 7-50
- OCI and Java LOB interactions, 7-52
- using in LONG-to-LOB migration, 8-17
- polling, 10-47, 10-50, 10-57, 10-86, 11-56
- populating your data repository, 14-4
- Pro*C/C++ precompiler
- available LOB functions, 3-3
- Pro*COBOL precompiler
- available LOB functions, 3-3
- programmatic environments, 3-2
- available functions, 3-3
- compared, 3-3
- putChars(), 6-12
R
- read consistency
- LOBs, 5-2
- read consistent locators, 5-2, 5-3, 5-11, 5-13, 5-24, 5-26, 5-27, 5-28
- reading
- BFILES
- specify 4 Gb-1 regardless of LOB, 12-56
- data fom temporary LOB, 11-28
- data from a LOB
- internal persistent LOBs, 10-56
- large amounts of LOB data using streaming, 10-47
- portion of BFILE data using substr, 12-59
- portion of LOB using substr
- internal persistent LOBs, 10-60
- portion of temporary LOB, 11-31
- small amounts of data,enable buffering, 10-101
- Recordsets, ADO, 13-3
- redo space
- during LONG-to-LOB migration, prevent generation, 9-10
- reference semantics, 2-3, 10-26
- BFILEs enables multiple BFILE columns per record, 12-7
- replication, 8-10
- restrictions
- binding of data, removed for INSERTS and UPDATES, 4-17
- binds of more than 4000 bytes, 7-16
- partitioned index-organized tables and LOBs, 5-31
- retrieving data, 14-9
- roundtrips to the server, avoiding, 5-19, 5-26
- Rowset, OLEDB, 13-2
S
- sample programs, 1-8
- searching for data, 14-6
- security
- BFILEs, 12-8
- BFILEs using SQL DDL, 12-9
- BFILEs using SQL DML, 12-10
- segment
- LOB restriction, must be a tleast 3 blocks, 4-16
- SEGMENT SPACE MANAGEMENT
- Auto, LOBs cannot be stored with, 4-16
- SELECT statement
- FOR UPDATE, 2-8
- read consistency, 5-2
- selecting a permanent LOB INTO a temporary LOB locator, 11-9
- semantics
- copy-based for internal LOBs, 10-26
- pseudo-reference, 11-10
- reference based for BFILEs, 12-7
- value, 11-10
- SESSION_MAX_OPEN_FILES parameter, 4-2, 12-41, 12-46
- setData
- setting to EMPTY_BLOB() using JPublisher, 6-10
- setting
- internal LOBs to empty, 2-10
- LOBs to NULL, 2-9
- space requirements,LONG-to-LOB migration, 8-10
- spatial cartridge and user-defined aggregates, 7-54
- SQL
- features where LOBs cannot be used, 7-40
- functions and operators,returning CLOB values from, 7-41
- RAW type and BLOBs, 7-44
- where LOBs cannot be used, 7-40
- SQL DDL
- BFILE security, 12-9
- SQL DML
- BFILE security, 12-10
- SQL Loader
- loading InLine LOB data, 4-7
- performance for internal LOBs, 4-6
- SQL semantics on LOBs
- non-supported functionality, 7-35
- SQL*Loader
- conventional path load, 9-3
- direct-path load, 9-3
- LOBFILE, 9-2
- storing
- CLOBs Inline, 6-23
- greater than 4GB LOBs in database (FAQ), 6-29
- LOB storage clause,when to use with varrays, 6-23
- storing images in a BFILE versus BLOB, 6-20
- stream
- reading
- temporary LOBs, 11-29
- writing, 11-56
- streaming, 10-50, 10-54
- do not enable buffering, when using, 10-101
- write, 10-89
- system owned object, See DIRECTORY object
T
- tablespace
- LOB index in same, FAQ, 6-18
- specified with ENABLE STORAGE IN ROW, FAQ, 6-19
- temporary, 11-8
- temporary LOB data stored in temporary, 11-7
- temporary LOBs
- character set ID, 11-47
- checking if LOB is temporary, 11-16
- data stored in temporary tablespace, 11-7
- disable buffering
- explcitly freeing before overwriting it with permanent LOB locator, 11-9
- features, 11-10
- inline and out-of-line not used, 11-7
- JDBC, 11-12
- lifetime and duration, 11-8
- locators can be IN values, 11-6
- locators operate as with permanent LOBs, 11-6
- memory handling, 11-8
- OCI and logical buckets, 11-8
- performance, 11-10
- reside on server not client, 11-8
- similar functions used to permanent LOBs, 11-7
- SQL DML does not operate on, 11-6
- transactions and consistent reads not suuported, 11-7
- trimming, 11-58
- write append to, 11-53
- temporary tablespace
- for binds of more than 4000 bytes, 7-14
- TO_BLOB(),TO_CHAR(), TO_NCHAR(), 7-48
- TO_CLOB()
- converting VARCHAR2,NVARCHAR2,NCLOB to CLOB, 7-48
- TO_LOB
- limitations, 10-42
- TO_NCLOB(), 7-48
- transaction boundaries
- LOB locators, 5-15
- transaction IDs, 5-15
- transactions
- external LOBs do not participate in, 2-3
- IDs of locators, 5-15
- internal LOBs participate fully, 2-2
- LOB locators cannot span, 5-13
- LOBs locators cannot span, 7-14
- locators with non-serializable, 5-16
- locators with serializable, 5-16
- migrating from, 5-24
- triggers
- LOB columns with, how to tell when updated (FAQ), 6-5
- LONG-to-LOB migration, 8-11
- trimming
- LOB data
- internal persistent LOBs, 10-93
- temporary LOB data, 11-58
- Trusted Oracle and user-defined aggregates, 7-54
U
- UDAGs, see user-defined aggregates
- UNICODE
- VARCHAR2 and CLOBs support, 7-39
- Unified Modeling Language (UML), A-1
- unstructured data, 1-2
- UPDATE statements
- binds of greater than 4000 bytes, 7-14
- updated locators, 5-6, 5-10, 5-23
- updating
- a row containing a BFILE, 12-82
- any length data (FAQ), 6-4
- avoid the LOB with different locators, 5-8
- BFILEs by selecting a BFILE from another table, 12-86
- BFILEs using BFILENAME(), 12-83
- by initializinga LOB locator bind variable
- internal persistent LOBs, 10-115
- by selecting a LOB from another table
- internal persistent LOBs, 10-113
- LOB values using one locator, 5-8
- LOB values, read consistent locators, 5-2
- LOB with PL/SQL bind variable, 5-10
- LOBs using SQL and DBMS_LOB, 5-6
- locking before, 10-70
- locking prior to, 10-83, 10-94, 10-98
- with EMPTY_CLOB()/EMPTY_BLOB()
- internal persistent LOBs, 10-110
- upding
- locators, 5-13
- UPLOAD_AS_BLOB and DAD, 6-32
- use case diagrams, A-1
- use cases
- full list of internal persistent LOBs, 10-2
- model, graphic summary of, 10-1
- user-defined aggregates (UDAGs) and LOBs, 7-54
- utldtree.sql, 8-24
V
- value of LOBs, 2-6
- VARCHAR2
- accessing CLOB data when treated as, 7-47
- also RAW,applied to CLOBs and BLOBs, 7-40
- defining CLOB variable on, 7-47
- OCI and JDBC now bind and define variables to SQL, PL/SQL with LOBs, 7-52
- VARCHAR2s
- on CLOBs,SQL functions and operators for, 7-35
- VARRAYs
- See creating VARRAYs
- varrays
- including LOB storage clause to create tables (FAQ), 6-23
- varying-width character data, 2-4
- Veritas with LOBs, 6-26
- views on DIRECTORY object, 12-10
- Visual Basic, See Oracle Objects for OLE(OO4O)
W
- web-sites, building LOB-based, 14-12
- write
- streaming, 11-56
- write appending
- to temporary LOBs, 11-53
- writing
- data to a LOB
- internal persistent LOBs, 10-88
- data to a temporary LOB, 11-55
- singly or piecewise, 10-86
- small amounts of data, enable buffering, 10-101
X
- XML, loading, 9-2