Skip Headers
Oracle® Database SecureFiles and Large Objects Developer's Guide
11g Release 2 (11.2)

Part Number E18294-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  H  I  J  K  L  M  N  O  P  R  S  T  U  V  W  Z 

A

abstract datatypes and LOBs, 1.8
access statistics for LOBs, 14.3
accessing a LOB
using the LOB APIs, 2.6.3
accessing external LOBs, 21.2
ALTER TABLE, 4.3
ALTER TABLE parameters for SecureFiles LOBs, 4.3
amount, 21.13
amount parameter
used with BFILEs, 21.7
appending
writing to the end of a LOB
internal persistent LOBs, 22.20
array read, 22.11
array write, 22.22
assigning OCILobLocator pointers, 13.4.6
ASSM tablespace, 4.2, 4.2.1.2, 4.5, 4.7.4, 11.3.2, 11.3.2, 11.3.6, 18.4.3
available LOB methods, 13.2

B

BASICFILE
LOB storage parameter, 4.2.1.1
BFILE class, See JDBC
BFILE-buffering, See JDBC
BFILENAME function, 2.5.2.2, 21.4, 21.5.1
BFILEs
accessing, 21.2
converting to CLOB or NCLOB, 21.7
creating an object in object cache, 12.5
datatype, 1.7
DBMS_LOB read-only procedures, 13.3.8
DBMS_LOB, offset and amount parameters in bytes, 13.3.2
hard links and symbolic links not allowed, 3.3.1
locators, 2.5
maximum number of open, 3.3.2, 3.3.2, 21.18
maximum size, 12.6, 12.6
multithreaded server, 2.7.2
multithreaded server mode, 21.6.7
not affected by LOB storage properties, 11.3.1
OCI functions to read/examine values, 13.4.10, 13.5.10
OCI read-only functions, 13.4.12, 13.5.11
opening and closing using JDBC, 13.9.21
operating system files, and, 3.3.1
Oracle Objects for OLE (OO4O)
opening/closing methods, 13.8.7
properties, 13.8.11
read-only methods, 13.8.10
Pro*C/C++ precompiler statements, 13.6.6
Pro*COBOL precompiler embedded SQL statements, 13.7.6
reading with DBMS_LOB, 13.3.6
rules for using, 3.3.1
security, 21.5.1, 21.6
storage devices, 1.4.2
storing any operating system file, 1.7
streaming APIs, 13.9.25
using JDBC to read/examine, 13.9.15
using Pro*C/C++ precompiler to open and close, 13.6.9
bind variables, used with LOB locators in OCI, 13.4.7
binds
See also INSERT statements and UPDATE statements
Blob class, 13.5.1.2
BLOB-buffering, See JDBC
BLOBs
class, See JDBC
datatype, 1.7
DBMS_LOB, offset and amount parameters in bytes, 13.3.2
maximum size, 12.6
modify using DBMS_LOB, 13.3.5
using JDBC to modify, 13.9.9
using JDBC to read/examine BLOB values, 13.9.10
using oracle.sql.BLOB methods to modify, 13.9.9
buffering
disable
internal persistent LOBs, 22.27
enable
internal persistent LOBs, 22.25
flush
internal persistent LOBs, 22.26
LOB buffering subsystem, 12.1.3.2
built-in functions, remote, 16.6

C

C++, See Pro*C/C++ precompiler
C, See OCI
CACHE / NOCACHE, 11.3.8
caches
object cache, 12.5
callback, 21.13, 22.10, 22.20
CAST, 17.3
catalog views
v$temporary_lobs, 3.2
character data
varying width, 11.2.2
character set ID, 13.3.3
getting the
internal persistent LOBs, 22.4
See CSID parameter
charactersets
multibyte, LONG and LOB datatypes, 20.4.3
CHUNK, 4.2.1.3, 11.3.11, 12.6.1
chunk size, 22.21
and LOB storage properties, 11.3.1
multiple of, to improve performance, 22.10
CLOB class, See JDBC
CLOB-buffering, See JDBC
CLOBs
columns
varying- width character data, 11.2.2
datatype, 1.7
varying-width columns, 11.2.2
DBMS_LOB, offset and amount parameters in characters, 13.3.2
modify using DBMS_LOB, 13.3.5
opening and closing using JDBC, 13.9.20
reading/examining with JDBC, 13.9.13
using JDBC to modify, 13.9.12
Clone method, See Oracle Objects for OLE (OO4O)
closing
all open BFILEs, 21.24
BFILEs with CLOSE, 21.23
BFILEs with FILECLOSE, 21.22
clustered tables, 18.5.1
COBOL, See Pro*COBOL precompiler
codepoint semantics, 16.2.2
COM, See Oracle Objects for OLE(OO4O)
comparing
all or part of two LOBs
internal persistent LOBs, 22.13
all or parts of two BFILEs, 21.15
COMPRESS, 4.2.1.10, 4.3.1.2
conventional path load, 3.1.1
conversion
explicit functions for PL/SQL, 17.3
conversion, implicit from CLOB to character type, 16.2
conversions
character set, 21.7
from binary data to character set, 21.7
implicit, between CLOB and VARCHAR2, 17.2
converting
to CLOB, 17.3
copy semantics, 1.6
internal LOBs, 15.3
copying
all or part of a LOB to another LOB
internal persistent LOBs, 22.16
LOB locator
internal persistent LOBs, 22.17
LOB locator for BFILE, 21.19
CREATE TABLE parameters for SecureFiles LOBs, 4.2
CREATE TABLE syntax and notes, 4.2
CSID parameter
setting OCILobRead and OCILobWrite to OCI_UCS2ID, 13.4.2

D

data interface for persistent LOBs, 20
multibyte charactersets, 20.4.3
data interface for remote LOBs, 20.6
data interface in Java, 20.5
Data Pump, 3.1.3, 18.4.4
database file system links, 4.4
db_securefile init.ora parameter, 4.5
DBFS Administration, 6.4
DBFS Command Interface, 6.3
DBFS Content API, 7.1
DBFS installation, 6.1
DBFS links, 4.4
DBFS Mounting Interface (Linux Only), 6.2
DBFS using Oracle Wallet, 6.4.1
DBMS_LOB
updating LOB with bind variable, 12.3.6
DBMS_LOB functions on a NULL LOB restriction, 11.1.1.1
DBMS_LOB package, 4.8.1
available LOB procedures/functions, 13.2, 13.2
for temporary LOBs, 13.3.7
functions/procedures to modify BLOB, CLOB, and NCLOB, 13.3.5
functions/procedures to read/examine internal and external LOBs, 13.3.6
LOADBLOBFROMFILE, 21.7
LOADCLOBFROMFILE, 21.7
LOADFROMFILE(), 21.7
multithreaded server, 2.7.2
multithreaded server mode, 21.6.7
offset and amount parameter guidelines, 13.3.2
open and close, JDBC replacements for, 13.9.18
opening/closing internal and external LOBs, 13.3.9
provide LOB locator before invoking, 13.3.1
read-only functions/procedures for BFILEs, 13.3.8
to work with LOBs, using, 13.3
WRITE()
guidelines, 22.21
DBMS_LOB.GET_STORAGE_LIMIT, 12.6.3
DBMS_LOB.GETCHUNKSIZE, 12.6.1
DBMS_LOB.GETLENGTH return value, 16.2.4
DBMS_LOB.GETOPTIONS, 4.8.1.1
DBMS_LOB.ISSECUREFILE, 4.8.1.3
DBMS_LOB.isTemporary, previous workaround for JDBC, 22.28.1
DBMS_LOB.LOADBLOBFROMFILE, 13.3.2
DBMS_LOB.LOADCLOBFROMFILE, 13.3.2
DBMS_LOB.LOADFROMFILE, 13.3.2
DBMS_LOB.READ, 21.13
DBMS_LOB.SETOPTIONS, 4.8.1.2
DBMS_LOB.WRITE()
passing hexadecimal string to, 22.21
DBMS_REDEFINITION, 4.3
DBMS_SPACE package, 4.8.2
DECRYPT, 4.2.1.12, 4.3.1.4
DEDUPLICATE, 4.2.1.11, 4.3.1.3
directories
catalog views, 21.6.5
guidelines for usage, 21.6.6
ownership and privileges, 21.6.1
DIRECTORY name specification, 21.5.1
DIRECTORY object
catalog views, 21.6.5
getting the alias and filename, 21.20
guidelines for usage, 21.6.6
names on Windows platforms, 21.5.1.1
naming convention, 21.5.1
READ permission on object not individual files, 21.6.2
rules for using, 3.3.1
symbolic links, 3.3.1
symbolic links, and, 3.3.1
DIRECTORY objects, 21.3
direct-path load, 3.1.1
DISABLE STORAGE IN ROW, 11.3.1
displaying
LOB data for internal persistent LOBs, 22.9
domain indexing on LOB columns, 11.4.1

E

embedded SQL statements, See Pro*C/C++ precompiler and Pro*COBOL precompiler
empty LOBs
creating using JDBC, 13.9.26
JDBC, 13.9.26
EMPTY_BLOB() and EMPTY_CLOB, LOB storage properties for, 11.3.1
EMPTY_CLOB()/BLOB()
to initialize internal LOB, 2.5.2.1
ENABLE STORAGE IN ROW, 11.3.1
ENCRYPT, 4.2.1.12, 4.3.1.4
equal
one LOB locator to another
internal persistent LOBs, 22.18
erasing
part of LOB
internal persistent LOBs, 22.24
error message documentation, database, Preface
example, LOB access statistics, 14.3.1
examples
repercussions of mixing SQL DML with DBMS_LOB, 12.3.4
updated LOB locators, 12.3.5
updating a LOB with a PL/SQL variable, 12.3.6
existence
check for BFILE, 21.17
extensible indexes, 11.4.3
external callout, 12.1.5
external LOBs (BFILEs)
See BFILEs
external LOBs (BFILEs), See BFILEs

F

file system links, 4.4
FILECLOSEALL(), 21.6.6
FILESYSTEM_LIKE_LOGGING, 4.2.1.7
flushing
LOB buffer, 12.1.4
flushing buffer, 12.1.1
FOR UPDATE clause
LOB locator, 12.3.1
FREELIST GROUPS, 4.2.1.8
FREELISTS, 4.2.1.8
FREEPOOLS, 4.2.1.6, 4.2.1.9
function-based indexes, 11.4.3
function-based indexes on LOB columns, 11.4.3

H

hard links, rules with BFILEs, 3.3.1
hexadecimal string
passing to DBMS_LOB.WRITE(), 22.21

I

implicit assignment and parameter passing for LOB columns, 20.3.2
implicit conversion of CLOB to character type, 16.2
Improved LOB Usability, Accessing LOBs Using SQL Character Functions, 16.1
indexes
function-based, 11.4.3
rebuilding after LONG-to-LOB migration, 18.5.3
indexes on LOB columns
bitmap index not supported, 11.4.1
B-tree index not supported, 11.4.1
domain indexing, 11.4.1
restriction, 11.4
indexes, restrictions, 18.5.3
index-organized tables, restrictions for LOB columns, 11.7
initialization parameters for SecureFiles LOBs, 4.5
initializing
during CREATE TABLE or INSERT, 15.4
using EMPTY_CLOB(), EMPTY_BLOB(), 2.5.2.1
initializing a LOB column to a non-NULLvalue, 11.1.1.2
init.ora parameter db_securefile, 4.5
inline storage, 11.3.1
inline storage, maximum size, 11.3.1
INSERT statements
binds of greater than 4000 bytes, 20.3.7
inserting
a row by initializing a LOB locator
internal persistent LOBs, 15.5
a row by initializing BFILE locator, 21.25
Installing DBFS, 6.1
interfaces for LOBs, see programmatic environments
IS NULL return value for LOBs, 16.5.2
IS NULL usage with LOBs, 16.5.2

J

Java, See JDBC
java.sql.Blob, 13.9.1
java.sql.Clob, 13.9.1
JDBC
available LOB methods/properties, 13.2
BFILE class
BFILE streaming APIs, 13.9.25
BFILE-buffering, 13.9.16
BLOB and CLOB classes
calling DBMS_LOB package, 13.9.3
checking if BLOB is temporary, 22.28.1
CLOB streaming APIs, 13.9.24
empty LOBs, 13.9.26
encapsulating locators
methods/properties for BLOB-buffering, 13.9.11
methods/properties for CLOB-buffering, 13.9.14
modifying BLOB values, 13.9.9
modifying CLOB values, 13.9.12
modifyng internal LOBs with Java using objects oracle.sql.BLOB/CLOB, 13.9.1
newStreamLob.java, 13.9.25.1
opening and closing BFILEs, 13.9.21
opening and closing CLOBs, 13.9.20
opening and closing LOBs, 13.9.18
reading internal LOBs and external LOBs (BFILEs) with Java, 13.9.2
reading/examining BLOB values, 13.9.10
reading/examining CLOB values, 13.9.13
reading/examining external LOB (BFILE) values, 13.9.15
referencing LOBs, 13.9.6
streaming APIs for LOBs, 13.9.23
syntax references, 13.9.7
trimming LOBs, 13.9.22
using OracleResultSet to reference LOBs, 13.9.6.1
using OUT parameter from OraclePreparedStatement to reference LOBs, 13.9.6.1
writing to empty LOBs, 13.9.26
JDBC 3.0, 13.9.1
JDBC and Empty LOBs, 13.9.26

K

KEEP_DUPLICATES, 4.2.1.11, 4.3.1.3

L

LBS, See Lob Buffering Subsystem (LBS)
length
an internal persistent LOB, 22.15
getting BFILE, 21.18
LENGTH return value for LOBs, 16.2.4
loading
a LOB with BFILE data, 21.7
LOB with data from a BFILE, 22.5
LOB attributes
defined, 1.8
LOB buffering
BLOB-buffering with JDBC, 13.9.11
buffer-enabled locators, 12.1.6
example, 12.1.3.2
flushing the buffer, 12.1.4
flushing the updated LOB through LBS, 12.1.5
guidelines, 12.1.2
OCI example, 12.1.8
OCI functions, 13.4.14
OCILobFlushBuffer(), 12.1.4
Oracle Objects for OLE (OO4O)
methods for internal LOBs, 13.8.8
physical structure of buffer, 12.1.3.1
Pro*C/C++ precompiler statements, 13.6.8
Pro*COBOL precompiler statements, 13.7.8
usage notes, 12.1.3
LOB Buffering SubSystem (LBS)
LOB Buffering Subsystem (LBS)
advantages, 12.1.1
buffer-enabled locators, 12.1.5
buffering example using OCI, 12.1.8
example, 12.1.3.2
flushing
updated LOB, 12.1.5
flushing the buffer, 12.1.4
guidelines, 12.1
saving the state of locator to avoid reselect, 12.1.7
usage, 12.1.3
LOB columns
initializing internal LOB to a value, 11.1.3
initializing to contain locator, 2.5.2
initializing to NULL or Empty, 11.1.1
LOB locator
copy semantics, 1.6
external LOBs (BFILEs), 1.6
internal LOBs, 1.6
out-bind variables in OCI, 13.4.7
reference semantics, 1.6
LOB locators, always stored in row, 11.3.1
LOB prefetching
JDBC, 13.9.4
LOB reads, 14.3
LOB restrictions, 2.7
LOB storage
format of varying width character data, 11.2.2
inline and out-of-line storage properties, 11.3.1
LOB writes, 14.3
LOB writes unaligned, 14.3
LOBs
abstract datatypes, members of, 1.8
attributes and abstract datatypes, 1.8
attributes and object cache, 12.5
buffering
caveats, 12.1.1
pages can be aged out, 12.1.4
buffering subsystem, 12.1
buffering usage notes, 12.1.3
datatypes versus LONG, 1.3
external (BFILEs), 1.4.2
flushing, 12.1.1
in partitioned tables, 11.5
in the object cache, 12.5
interfaces, See programmatic environments
interMEDIA, 1.9.3
internal
creating an object in object cache, 12.5
internal LOBs
CACHE / NOCACHE, 11.3.8
CHUNK, 11.3.11
ENABLE | DISABLE STORAGE IN ROW, 11.3.12
initializing, 21.13
introduced, 1.4.1
locators, 2.5
locking before updating, 22.2, 22.16, 22.20, 22.21, 22.23, 22.24
LOGGING / NOLOGGING, 11.3.9
Oracle Objects for OLE (OO4O), modifying methods, 13.8.5
PCTVERSION, 11.3.5, 11.3.5
setting to empty, 11.1.1.2
tablespace and LOB index, 11.3.4
tablespace and storage characteristics, 11.3.2
transactions, 1.4.1
locators, 2.5, 12.3.1
maximum sizes allowed, 12.6
object cache, 12.5
piecewise operations, 12.3.3
read-consistent locators, 12.3.1
reason for using, 1.2
setting to contain a locator, 2.5.2
setting to NULL, 11.1.1.1
tables
creating indexes, 11.5.2
moving partitions, 11.5.3
splitting partitions, 11.5.4
unstructured data, 1.2.2
updated LOB locators, 12.3.3
varying-width character data, 11.2.3
LOBs, data interface for remote, 20.6
LOBs, data interface in Java, 20.5
locators, 2.5
BFILEs, 21.6.8
guidelines, 21.6.8.3
two rows can refer to the same file, 21.6.8.1
buffer-enabled, 12.1.6
external LOBs (BFILEs), 2.5
LOB, cannot span transactions, 12.4.4
multiple, 12.3.1
OCI functions, 13.4.13, 13.5.12
Pro*COBOL precompiler statements, 13.7.7
providing in Pro*COBOL precompiler, 13.7.1
read consistent, updating, 12.3.1
read-consistent, 12.1.4, 12.1.7, 12.3.1, 12.3.1, 12.3.6, 12.4.4
reading and writing to a LOB using, 12.4.1
saving the state to avoid reselect, 12.1.7
see if LOB locator is initialized
internal persistent LOBs, 22.19
selecting within a transaction, 12.4.3
selecting without current transaction, 12.4.2
setting column to contain, 2.5.2
transaction boundaries, 12.4
updated, 12.1.4, 12.3.3, 12.3.6
updating, 12.4.4
LOGGING, 4.2.1.7
migrating LONG-to-LOBs, 18.2.2
LOGGING / NOLOGGING, 11.3.9
LONG versus LOB datatypes, 1.3
LONG-to-LOB migration
ALTER TABLE, 18.4.1
benefits and concepts, 18.1
clustered tables, 18.5.1
LOGGING, 18.2.2
NULLs, 18.5.4
rebuilding indexes, 18.5.3
replication, 18.1
triggers, 18.5.2

M

MAXSIZE, 4.2.1.5
migrating
a table using online redefinition, 4.7.3
LONG to LOBs, see LONG-to-LOB, 18.1
LONG-to-LOB using ALTER TABLE, 18.4.1
LONG-to-LOBs, constraints maintained, 18.4.1.1
LONG-to-LOBs, indexing, 18.5.3
migrating to SecureFiles LOBs, 4.7
migration of LONG to LOB in parallel, 18.4.3
multibyte character sets, using with the data interface for LOBs, 20.4.3
multithreaded server
BFILEs, 2.7.2, 21.6.7, 21.6.7

N

national language support
NCLOBs, 1.7
NCLOBs
datatype, 1.7
DBMS_LOB, offset and amount parameters in characters, 13.3.2
modify using DBMS_LOB, 13.3.5
NewStreamLob.java, 13.9.25.1
NLS_CHARSET_ID, 13.3.3
NOCOMPRESS, 4.2.1.10, 4.3.1.2
NOCOPY, using to pass temporary LOB parameters by reference, 14.1.4
NOLOGGING, 4.2.1.7
ISNULL usage with LOBs, 16.5.2
NULL LOB value, LOB storage for, 11.3.1
NULL LOB values, LOB storage properties for, 11.3.1
NULL LOB, restrictions calling OCI and DBMS_LOB functions, 11.1.1.1

O

object cache, 12.5
creating an object in, 12.5
LOBs, 12.5
OCCI
compared to other interfaces, 13.2
LOB functionality, 13.5
OCCI Bfile class, 13.5.11
OCCI Blob class
read, 13.5.3
write, 13.5.3
OCCI Clob class, 13.5.1
read, 13.5.3
write, 13.5.3
OCI
available LOB functions, 13.2
character set rules, fixed-width and varying-width, 13.4.3
functions for BFILEs, 13.4.12, 13.5.11
functions for temporary LOBs, 13.4.11, 13.5.11
functions to modify internal LOB values, 13.4.9, 13.5.9
functions to open/close internal and external LOBs, 13.4.15, 13.5.13
functions to read or examine internal and external LOB values, 13.4.10, 13.5.10
LOB buffering example, 12.1.8
LOB locator functions, 13.4.13, 13.5.12
Lob-buffering functions, 13.4.14
NCLOB parameters, 13.4.3.2, 13.5.4.1
OCILobFileGetLength
CLOB and NCLOB input and output length, 13.4.3
OCILobRead2()
varying-width CLOB and NCLOB input and amount amounts, 13.4.3
OCILobWrite2()
varying-width CLOB and NCLOB input and amount amounts, 13.4.3, 13.5.3
offset and amount parameter rules
fixed-width character sets, 13.5.2
setting OCILobRead2(), OCILobWrite2() to OCI_UCS2ID, 13.4.2
using to work LOBs, 13.4
OCI functions on a NULL LOB restriction, 11.1.1.1
OCILobArrayRead(), 22.11
OCILobArrayWrite(), 22.22
OCILobAssign(), 12.1.2
OCILobFileSetName(), 21.5, 21.6.8.3
OCILobFlushBuffer(), 12.1.4
OCILobGetChunkSize(), 12.6.1, 12.6.4
OCILobGetStorageLimit(), 12.6.4
OCILobLoadFromFile(), 21.7, 21.7
OCILobLocator in assignment "=" operations, 13.4.6
OCILobLocator, out-bind variables, 13.4.7
OCILobRead2(), 21.13, 22.9, 22.10
BFILEs, 21.13
OCILobWriteAppend2(), 22.20
OCIObjectFlush(), 21.6.8.3
OCIObjectNew(), 21.6.8.3
OCISetAttr(), 21.6.8.3
ODP.NET, 13.2
offset parameter, in DBMS_LOB operations, 13.3.2
OLEDB, 13.10
OO4O, See Oracle Objects for OLE (OO4O)
open
checking for open BFILEs with FILEISOPEN(), 21.11
checking if BFILE is open with ISOPEN, 21.10
open, determining whether a LOB is open, 22.8
OpenCloseLob.java example, 13.9.21.4
opening
BFILEs using FILEOPEN, 21.9
BFILEs with OPEN, 21.8
opening and closing LOBs
using JDBC, 13.9.18
ORA-17098
empty LOBs and JDBC, 13.9.26
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, 13.2
internal LOB buffering, 13.8.8
methods and properties to access data stored in BLOBs, CLOBs, NCLOBs, and BFILEs, 13.8.4
modifying internal LOBs, 13.8.5
opening/closing external LOBs (BFILEs), 13.8.7
OraBfile example
OraBlob example
OraBlob, OraClob, and OraBfile encapsulate locators, 13.8.2
properties for operating on external LOBs (BFILEs), 13.8.11
properties for operating on LOBs, 13.8.9
reading/examining internal LOB and external LOB (BFile) values, 13.8.6
read-only methods for external LOBs (BFILEs), 13.8.10
syntax reference, 13.8.1
using Clone method to retain locator independent of dynaset, 13.8.2.2
OraclePreparedStatement, See JDBC
OracleResultSet, See JDBC
oracle.sql.BFILE
BFILE-buffering, 13.9.16
JDBC methods to read/examine BFILEs, 13.9.15
oracle.sql.BLOB
for modifying BLOB values, 13.9.9
reading/examining BLOB values, 13.9.10
See JDBC
oracle.sql.BLOBs
BLOB-buffering
oracle.sql.CLOB
CLOB-buffering
JDBC methods to read/examine CLOB values, 13.9.13
modifying CLOB values, 13.9.12
oracle.sql.CLOBs
See JDBC
OraOLEDB, 13.10
out-of-line storage, 11.3.1

P

parallel DML support, 20.3.11
parallel LONG-to-LOB migration, 18.4.3
partitioned index-organized tables
restrictions for LOB columns, 11.7
pattern
check if it exists in BFILE using instr, 21.16
see if it exists IN LOB using (instr)
internal persistent LOBs, 22.14
PCTINCREASE parameter, recommended value for LOBs, 12.7.1
PCTVERSION, 4.2.1.9, 11.3.5, 11.3.5
performance
guidelines
reading/writing large data chunks, 14.1.3
reading/writing large data chunks, temporary LOBs, 14.1.4
PL/SQL, 13.1
and LOBs, semantics changes, 17.1
changing locator-data linkage, 17.3.1
CLOB variables in, 17.3.1
CLOB variables in PL/SQL, 17.3.1
CLOB versus VARCHAR2 comparison, 17.4
CLOBs passed in like VARCHAR2s, 17.3.1
defining a CLOB Variable on a VARCHAR, 17.2
freeing temporary LOBs automatically and manually, 17.3.1
PL/SQL functions, remote, 17.5
PL/SQL packages for SecureFiles LOB, 4.8
PM schema, 2.5.1
polling, 21.13, 22.10, 22.20
prefetching data, 13.4.1
print_media creation, 15.1
print_media table definition, 2.5.1
Pro*C/C++ precompiler
available LOB functions, 13.2, 13.2
LOB buffering, 13.6.8
locators, 13.6.7
modifying internal LOB values, 13.6.3
opening and closing internal LOBs and external LOBs (BFILEs), 13.6.9
providing an allocated input locator pointer, 13.6.1
reading or examining internal and external LOB values, 13.6.4
statements for BFILEs, 13.6.6
statements for temporary LOBs, 13.6.5
Pro*COBOL precompiler
available LOB functions, 13.2
LOB buffering, 13.7.8
locators, 13.7.7
modifying internal LOB values, 13.7.3
providing an allocated input locator, 13.7.1
reading or examining internal and external LOBs, 13.7.4
statements for BFILEs, 13.7.6
temporary LOBs, 13.7.5
programmatic environments
available functions, 13.2
compared, 13.2
programmatic environments for LOBs, 13.1

R

read consistency
LOBs, 12.3.1
read-consistent locators, 12.1.4, 12.1.7, 12.3, 12.3.1, 12.3.6, 12.4.4
reading
data from a LOB
internal persistent LOBs, 22.10
large data chunks, performance guidelines, 14.1.3
large data chunks, temporary LOBs, 14.1.4
portion of BFILE data using substr, 21.14
portion of LOB using substr
internal persistent LOBs, 22.12
small amounts of data, enable buffering, 22.25
reference semantics, 15.3, 15.3
BFILEs enables multiple BFILE columns for each record, 21.4
remote built-in functions, 16.6
remote PL/SQL functions, 17.5
replication, 18.1
restrictions
binds of more than 4000 bytes, 20.3.10
cannot call OCI or DBMS_LOB functions on a NULL LOB, 11.1.1.1
clustered tables, 18.5.1
indexes, 18.5.3
index-organized tables and LOBs, 11.7
LOBs, 2.7
replication, 18.1
triggers, 18.5.2
RETENTION, 4.2.1.4, 4.3.1.1
RETENTION ignored in an MSSM tablespace, 11.3.6
retrieving LOB access statistics, 14.3.1
RETURNING clause, using with INSERT to initialize a LOB, 11.1.1.2
round-trips to the server, avoiding, 12.1.1, 12.1.7
rules for using directory objects and BFILEs, 3.3.1

S

sample schema for examples, 15.1
SECUREFILE
ALTER TABLE parameters, 4.3
LOB storage parameter, 4.2.1.2
SecureFiles LOB
CREATE TABLE parameter, 4.2
PL/SQL, 4.8
SecureFiles LOBs
initialization parameters, 4.5
security
BFILEs, 21.5.1, 21.6
BFILEs using SQL DDL, 21.6.3
BFILEs using SQL DML, 21.6.4
SELECT statement
read consistency, 12.3.1
semantics
copy-based for internal LOBs, 15.3
reference based for BFILEs, 21.4
SESSION_MAX_OPEN_FILES parameter, 3.3.2, 3.3.2
setting
internal LOBs to empty, 11.1.1.2
LOBs to NULL, 11.1.1.1
overrides for NLS_LANG variable
SHRINK parameter of ALTER TABLE, 4.3
SHRINK parameter of CREATE TABLE, 4.2
SQL
Character Functions, improved, 16.1
features where LOBs cannot be used, 16.4
SQL DDL
BFILE security, 21.6.3
SQL DML
BFILE security, 21.6.4
SQL functions on LOBs
return type, 16.2.3
return value, 16.2.3
temporary LOBs returned, 16.2.3
SQL semantics and LOBs, 16.4
SQL semantics supported for use with LOBs, 16.2
SQL*Loader
conventional path load, 3.1.1
direct-path load, 3.1.1
statistics, access, 14.3
store, 7.2
streaming, 22.9
do not enable buffering, when using, 22.25
write, 22.21
streaming APIs
NewStreamLob.java, 13.9.25.1
using JDBC and BFILEs, 13.9.25
using JDBC and CLOBs, 13.9.24
using JDBC and LOBs, 13.9.23
symbolic links, rules with DIRECTORY objects and BFILEs, 3.3.1
system owned object, See DIRECTORY object

T

temporary BLOB
checking if temporary using JDBC, 22.28.1
temporary LOBs
checking if LOB is temporary, 22.28
DBMS_LOB available functions/procedures, 13.3.7
OCI functions, 13.4.11, 13.5.11
Pro*C/C++ precompiler embedded SQL statements, 13.6.5
Pro*COBOL precompiler statements, 13.7.5
returned from SQL functions, 16.2.3
TO_BLOB(),TO_CHAR(), TO_NCHAR(), 17.3
TO_CHAR(), 17.3
TO_CLOB()
converting VARCHAR2,NVARCHAR2,NCLOB to CLOB, 17.3
TO_NCLOB(), 17.3
transaction boundaries
LOB locators, 12.4
transaction IDs, 12.4.1
transactions
external LOBs do not participate in, 1.5
IDs of locators, 12.4
internal LOBs participate in database transactions, 1.4.1
LOB locators cannot span, 12.4.4
locators with non-serializable, 12.4.1
locators with serializable, 12.4.1
migrating from, 12.1.5
transparent read, 4.4.6
triggers
LONG-to-LOB migration, 18.5.2
trimming
LOB data
internal persistent LOBs, 22.23
trimming LOBs using JDBC, 13.9.22

U

UB8MAXVAL is BFILE maximum size, 12.6
UCS2 Unicode character set
varying width character data, 11.2.2
UNICODE
VARCHAR2 and CLOBs support, 16.2.1
unstructured data, 1.2.2
UPDATE statements
binds of greater than 4000 bytes, 20.3.7
updated locators, 12.1.4, 12.3.3, 12.3.6
updating
avoid the LOB with different locators, 12.3.5
LOB values using one locator, 12.3.5
LOB values, read consistent locators, 12.3.1
LOB with PL/SQL bind variable, 12.3.6
LOBs using SQL and DBMS_LOB, 12.3.4
locators, 12.4.4
locking before, 22.16
locking prior to, 22.2, 22.23, 22.24

V

V$NLS_VALID_VALUES, 13.3.3
VARCHAR2
accessing CLOB data when treated as, 17.2
also RAW, applied to CLOBs and BLOBs, 16.5
defining CLOB variable on, 17.2
VARCHAR2, using SQL functions and operators with LOBs, 16.2
VARRAY
LOB restriction, 2.7.1
varying-width character data, 11.2.2
views on DIRECTORY object, 21.6.5

W

Wallet,Oracle, 6.4.1
WHERE Clause Usage with LOBs, 16.5.3
writing
data to a LOB
internal persistent LOBs, 22.21
large data chunks, performance guidelines, 14.1.3
large data chunks, temporary LOBs, 14.1.4
singly or piecewise, 22.20
small amounts of data, enable buffering, 22.25

Z

Zero-copy Input/Output for SecureFiles LOBs, 13.9.5