Index

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

A

abstract datatypes and LOBs, 1.8

access statistics for LOBs, 8.3

accessing a LOB

using the LOB APIs, 2.6.3

accessing external LOBs, 16.2

ALTER TABLE, 4.1.8

ALTER TABLE parameters for SECUREFILE LOBs, 4.1.8

amount, 16.13

amount parameter

used with BFILEs, 16.7

appending

writing to the end of a LOB

internal persistent LOBs, 15.20

array read, 15.11

array write, 15.22

assigning OCILobLocator pointers, 7.4.6

ASSM tablespace, 4.1.1, 4.1.1.2, 4.3.1, 4.5.4, 5.3.2, 5.3.2, 12.4.3

available LOB methods, 7.2

B

BASICFILE

LOB storage parameter, 4.1.1.1

BFILE class, See JDBC

BFILE-buffering, See JDBC

BFILENAME function, 2.5.2.2, 16.4, 16.5.1

BFILEs

accessing, 16.2

converting to CLOB or NCLOB, 16.7

creating an object in object cache, 6.5

datatype, 1.7

DBMS_LOB read-only procedures, 7.3.8

DBMS_LOB, offset and amount parameters in bytes, 7.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, 16.18

maximum size, 6.6, 6.6

multithreaded server, 2.7.2

multithreaded server mode, 16.6.7

not affected by LOB storage properties, 5.3.1

OCI functions to read/examine values, 7.4.10, 7.5.10

OCI read-only functions, 7.4.12, 7.5.11

opening and closing using JDBC, 7.9.19

operating system files, and, 3.3.1

Oracle Objects for OLE (OO4O)

opening/closing methods, 7.8.7

properties, 7.8.11

read-only methods, 7.8.10

Pro*C/C++ precompiler statements, 7.6.6

Pro*COBOL precompiler embedded SQL statements, 7.7.6

reading with DBMS_LOB, 7.3.6

rules for using, 3.3.1

security, 16.5.1, 16.6

storage devices, 1.4.2

storing any operating system file, 1.7

streaming APIs, 7.9.23

using JDBC to read/examine, 7.9.13

using Pro*C/C++ precompiler to open and close, 7.6.9

bind variables, used with LOB locators in OCI, 7.4.7

binds

See also INSERT statements and UPDATE statements

Blob class, 7.5.1.2

BLOB-buffering, See JDBC

BLOBs

class, See JDBC

datatype, 1.7

DBMS_LOB, offset and amount parameters in bytes, 7.3.2

maximum size, 6.6

modify using DBMS_LOB, 7.3.5

using JDBC to modify, 7.9.7

using JDBC to read/examine BLOB values, 7.9.8

using oracle.sql.BLOB methods to modify, 7.9.7

buffering

disable

internal persistent LOBs, 15.27

enable

internal persistent LOBs, 15.25

flush

internal persistent LOBs, 15.26

LOB buffering subsystem, 6.1.3.2

built-in functions, remote, 10.6

C

C++, See Pro*C/C++ precompiler

C, See OCI

CACHE /NOCACHE, 5.3.8

caches

object cache, 6.5

callback, 15.10, 15.20, 16.13

CAST, 11.3

catalog views

v$temporary_lobs, 3.2

character data

varying width, 5.2.2

character set ID, 7.3.3

getting the

internal persistent LOBs, 15.4

See CSID parameter

charactersets

multibyte, LONG and LOB datatypes, 14.4.3

CHUNK, 4.1.1.3, 5.3.11, 6.6.1

chunk size, 15.21

and LOB storage properties, 5.3.1

multiple of, to improve performance, 15.10

CLOB class, See JDBC

CLOB-buffering, See JDBC

CLOBs

columns

varying- width character data, 5.2.2

datatype, 1.7

varying-width columns, 5.2.2

DBMS_LOB, offset and amount parameters in characters, 7.3.2

modify using DBMS_LOB, 7.3.5

opening and closing using JDBC, 7.9.18

reading/examining with JDBC, 7.9.11

using JDBC to modify, 7.9.10

Clone method, See Oracle Objects for OLE (OO4O)

closing

all open BFILEs, 16.24

BFILEs with CLOSE, 16.23

BFILEs with FILECLOSE, 16.22

clustered tables, 12.5.1

COBOL, See Pro*COBOL precompiler

codepoint semantics, 10.2.2

COM, See Oracle Objects for OLE(OO4O)

comparing

all or part of two LOBs

internal persistent LOBs, 15.13

all or parts of two BFILEs, 16.15

COMPRESS, 4.1.1.10, 4.1.8.2

conventional path load, 3.1.1

conversion

explicit functions for PL/SQL, 11.3

conversion, implicit from CLOB to character type, 10.2

conversions

character set, 16.7

from binary data to character set, 16.7

implicit, between CLOB and VARCHAR2, 11.2

converting

to CLOB, 11.3

copy semantics, 1.6

internal LOBs, 9.3

copying

all or part of a LOB to another LOB

internal persistent LOBs, 15.16

LOB locator

internal persistent LOBs, 15.17

LOB locator for BFILE, 16.19

CREATE TABLE parameters for SecureFile, 4.1.1

CREATE TABLE syntax and notes, 4.1.1

CSID parameter

setting OCILobRead and OCILobWrite to OCI_UCS2ID, 7.4.2

D

data interface for persistent LOBs, 14

multibyte charactersets, 14.4.3

data interface for remote LOBs, 14.6

data interface in Java, 14.5

db_securefile init.ora parameter, 4.3

DBMS_LOB

updating LOB with bind variable, 6.3.6

WRITE()

passing hexadecimal string to, 15.21

DBMS_LOB functions on a NULL LOB restriction, 5.1.1.1

DBMS_LOB package, 4.2.1

available LOB procedures/functions, 7.2, 7.2

for temporary LOBs, 7.3.7

functions/procedures to modify BLOB, CLOB, and NCLOB, 7.3.5

functions/procedures to read/examine internal and external LOBs, 7.3.6

LOADBLOBFROMFILE, 16.7

LOADCLOBFROMFILE, 16.7

LOADFROMFILE(), 16.7

multithreaded server, 2.7.2

multithreaded server mode, 16.6.7

offset and amount parameter guidelines, 7.3.2

open and close, JDBC replacements for, 7.9.16

opening/closing internal and external LOBs, 7.3.9

provide LOB locator before invoking, 7.3.1

read-only functions/procedures for BFILEs, 7.3.8

to work with LOBs, using, 7.3

WRITE()

guidelines, 15.21

DBMS_LOB.GET_STORAGE_LIMIT, 6.6.3

DBMS_LOB.GETCHUNKSIZE, 6.6.1

DBMS_LOB.GETLENGTH return value, 10.2.4

DBMS_LOB.isTemporary, previous workaround for JDBC, 15.28.1

DBMS_LOB.LOADBLOBFROMFILE, 7.3.2

DBMS_LOB.LOADCLOBFROMFILE, 7.3.2

DBMS_LOB.LOADFROMFILE, 7.3.2

DBMS_LOB.READ, 16.13

DBMS_REDEFINITION, 4.1.8

DBMS_SPACE package, 4.2.2

DECRYPT, 4.1.1.11, 4.1.8.3

DEDUPLICATE, 4.1.1.12, 4.1.8.1

directories

catalog views, 16.6.5

guidelines for usage, 16.6.6

ownership and privileges, 16.6.1

DIRECTORY name specification, 16.5.1

DIRECTORY object

catalog views, 16.6.5

getting the alias and filename, 16.20

guidelines for usage, 16.6.6

names on Windows platforms, 16.5.1.1

naming convention, 16.5.1

READ permission on object not individual files, 16.6.2

rules for using, 3.3.1

symbolic links, 3.3.1

symbolic links, and, 3.3.1

DIRECTORY objects, 16.3

direct-path load, 3.1.1

DISABLE STORAGE IN ROW, 5.3.1

displaying

LOB data for internal persistent LOBs, 15.9

domain indexing on LOB columns, 5.4.1

E

embedded SQL statements, See Pro*C/C++ precompiler and Pro*COBOL precompiler

empty LOBs

creating using JDBC, 7.9.24

JDBC, 7.9.24

EMPTY_BLOB() and EMPTY_CLOB, LOB storage properties for, 5.3.1

EMPTY_CLOB()/BLOB()

to initialize internal LOB, 2.5.2.1

ENABLE STORAGE IN ROW, 5.3.1

ENCRYPT, 4.1.1.11, 4.1.8.3

equal

one LOB locator to another

internal persistent LOBs, 15.18

erasing

part of LOB

internal persistent LOBs, 15.24

error message documentation, database, Preface

example, LOB access statistics, 8.3.1

examples

repercussions of mixing SQL DML with DBMS_LOB, 6.3.4

updated LOB locators, 6.3.5

updating a LOB with a PL/SQL variable, 6.3.6

existence

check for BFILE, 16.17

extensible indexes, 5.4.3

external callout, 6.1.5

external LOBs (BFILEs)

See BFILEs

external LOBs (BFILEs), See BFILEs

F

FILECLOSEALL(), 16.6.6

FILESYSTEM_LIKE_LOGGING, 4.1.1.7

flushing

LOB buffer, 6.1.4

flushing buffer, 6.1.1

FOR UPDATE clause

LOB locator, 6.3.1

FREELIST GROUPS, 4.1.1.8

FREELISTS, 4.1.1.8

FREEPOOLS, 4.1.1.6, 4.1.1.9

function-based indexes, 5.4.3

function-based indexes on LOB columns, 5.4.3

H

hard links, rules with BFILEs, 3.3.1

hexadecimal string

passing to DBMS_LOB.WRITE(), 15.21

I

implicit assignment and parameter passing for LOB columns, 14.3.2

implicit conversion of CLOB to character type, 10.2

Improved LOB Usability, Accessing LOBs Using SQL Character Functions, 10.1

indexes

function-based, 5.4.3

rebuilding after LONG-to-LOB migration, 12.5.3

indexes on LOB columns

bitmap index not supported, 5.4.1

B-tree index not supported, 5.4.1

domain indexing, 5.4.1

indexes, restrictions, 12.5.3

index-organized tables, restrictions for LOB columns, 5.7

initialization parameters for SecureFile, 4.3

initializing

during CREATE TABLE or INSERT, 9.4

using EMPTY_CLOB(), EMPTY_BLOB(), 2.5.2.1

initializing a LOB column to a non-null value, 5.1.1.2

init.ora parameter db_securefile, 4.3

inline storage, 5.3.1

inline storage, maximum size, 5.3.1

INSERT statements

binds of greater than 4000 bytes, 14.3.7

inserting

a row by initializing a LOB locator

internal persistent LOBs, 9.5

a row by initializing BFILE locator, 16.25

interfaces for LOBs, see programmatic environments

IS NULL return value for LOBs, 10.5.2

IS NULL usage with LOBs, 10.5.2

J

Java, See JDBC

java.sql.Blob, 7.9.1

java.sql.Clob, 7.9.1

JDBC

available LOB methods/properties, 7.2

BFILE class

BFILE streaming APIs, 7.9.23

BFILE-buffering, 7.9.14

BLOB and CLOB classes

calling DBMS_LOB package, 7.9.3

checking if BLOB is temporary, 15.28.1

CLOB streaming APIs, 7.9.22

empty LOBs, 7.9.24

encapsulating locators

methods/properties for BLOB-buffering, 7.9.9

methods/properties for CLOB-buffering, 7.9.12

modifying BLOB values, 7.9.7

modifying CLOB values, 7.9.10

modifyng internal LOBs with Java using objects oracle.sql.BLOB/CLOB, 7.9.1

newStreamLob.java, 7.9.23.1

opening and closing BFILEs, 7.9.19

opening and closing CLOBs, 7.9.18

opening and closing LOBs, 7.9.16

reading internal LOBs and external LOBs (BFILEs) with Java, 7.9.2

reading/examining BLOB values, 7.9.8

reading/examining CLOB values, 7.9.11

reading/examining external LOB (BFILE) values, 7.9.13

referencing LOBs, 7.9.4

streaming APIs for LOBs, 7.9.21

syntax references, 7.9.5

trimming LOBs, 7.9.20

using OracleResultSet to reference LOBs, 7.9.4.1

using OUT parameter from OraclePreparedStatement to reference LOBs, 7.9.4.1

writing to empty LOBs, 7.9.24

JDBC 3.0, 7.9.1

JDBC and Empty LOBs, 7.9.24

K

KEEP_DUPLICATES, 4.1.1.12, 4.1.8.1

L

LBS, See Lob Buffering Subsystem (LBS)

length

an internal persistent LOB, 15.15

getting BFILE, 16.18

LENGTH return value for LOBs, 10.2.4

a LOB with BFILE data, 16.7

LOB with data from a BFILE, 15.5

LOB attributes

defined, 1.8

LOB buffering

BLOB-buffering with JDBC, 7.9.9

buffer-enabled locators, 6.1.6

example, 6.1.3.2

flushing the buffer, 6.1.4

flushing the updated LOB through LBS, 6.1.5

guidelines, 6.1.2

OCI example, 6.1.8

OCI functions, 7.4.14

OCILobFlushBuffer(), 6.1.4

Oracle Objects for OLE (OO4O)

methods for internal LOBs, 7.8.8

physical structure of buffer, 6.1.3.1

Pro*C/C++ precompiler statements, 7.6.8

Pro*COBOL precompiler statements, 7.7.8

usage notes, 6.1.3

LOB Buffering SubSystem (LBS)

LOB Buffering Subsystem (LBS)

advantages, 6.1.1

buffer-enabled locators, 6.1.5

buffering example using OCI, 6.1.8

example, 6.1.3.2

flushing

updated LOB, 6.1.5

flushing the buffer, 6.1.4

guidelines, 6.1

saving the state of locator to avoid reselect, 6.1.7

usage, 6.1.3

LOB columns

initializing internal LOB to a value, 5.1.3

initializing to contain locator, 2.5.2

initializing to NULL or Empty, 5.1.1

LOB locator

copy semantics, 1.6

external LOBs (BFILEs), 1.6

internal LOBs, 1.6

out-bind variables in OCI, 7.4.7

reference semantics, 1.6

LOB locators, always stored in row, 5.3.1

LOB reads, 8.3

LOB restrictions, 2.7

LOB storage

format of varying width character data, 5.2.2

inline and out-of-line storage properties, 5.3.1

LOB writes, 8.3

LOB writes unaligned, 8.3

LOBs

abstract datatypes, members of, 1.8

attributes and abstract datatypes, 1.8

attributes and object cache, 6.5

buffering

caveats, 6.1.1

pages can be aged out, 6.1.4

buffering subsystem, 6.1

buffering usage notes, 6.1.3

datatypes versus LONG, 1.3

external (BFILEs), 1.4.2

flushing, 6.1.1

in partitioned tables, 5.5

in the object cache, 6.5

interfaces, See programmatic environments

interMEDIA, 1.9.3

internal

creating an object in object cache, 6.5

internal LOBs

CACHE /NOCACHE, 5.3.8

CHUNK, 5.3.11

ENABLE | DISABLE STORAGE IN ROW, 5.3.12

initializing, 16.13

introduced, 1.4.1

locators, 2.5

locking before updating, 15.2, 15.16, 15.20, 15.21, 15.23, 15.24

LOGGING /NOLOGGING, 5.3.9

Oracle Objects for OLE (OO4O), modifying methods, 7.8.5

PCTVERSION, 5.3.5, 5.3.5

setting to empty, 5.1.1.2

tablespace and LOB index, 5.3.4

tablespace and storage characteristics, 5.3.2

transactions, 1.4.1

locators, 2.5, 6.3.1

maximum sizes allowed, 6.6

object cache, 6.5

piecewise operations, 6.3.3

read-consistent locators, 6.3.1

reason for using, 1.2

setting to contain a locator, 2.5.2

setting to NULL, 5.1.1.1

tables

creating indexes, 5.5.2

moving partitions, 5.5.3

splitting partitions, 5.5.4

unstructured data, 1.2.2

updated LOB locators, 6.3.3

varying-width character data, 5.2.3

LOBs, data interface for remote, 14.6

LOBs, data interface in Java, 14.5

locators, 2.5

BFILEs, 16.6.8

guidelines, 16.6.8.3

two rows can refer to the same file, 16.6.8.1

buffer-enabled, 6.1.6

external LOBs (BFILEs), 2.5

LOB, cannot span transactions, 6.4.4

multiple, 6.3.1

OCI functions, 7.4.13, 7.5.12

Pro*COBOL precompiler statements, 7.7.7

providing in Pro*COBOL precompiler, 7.7.1

read consistent, updating, 6.3.1

read-consistent, 6.1.4, 6.1.7, 6.3.1, 6.3.1, 6.3.6, 6.4.4

reading and writing to a LOB using, 6.4.1

saving the state to avoid reselect, 6.1.7

see if LOB locator is initialized

internal persistent LOBs, 15.19

selecting within a transaction, 6.4.3

selecting without current transaction, 6.4.2

setting column to contain, 2.5.2

transaction boundaries, 6.4

updated, 6.1.4, 6.3.3, 6.3.6

updating, 6.4.4

LOGGING, 4.1.1.7

migrating LONG-to-LOBs, 12.2.2

LOGGING /NOLOGGING, 5.3.9

LONG versus LOB datatypes, 1.3

LONG-to-LOB migration

ALTER TABLE, 12.4.1

benefits and concepts, 12.1

clustered tables, 12.5.1

LOGGING, 12.2.2

NULLs, 12.5.4

rebuilding indexes, 12.5.3

replication, 12.1

triggers, 12.5.2

M

MAXSIZE, 4.1.1.5

migrating

LONG to LOBs, see LONG-to-LOB, 12.1

LONG-to-LOB using ALTER TABLE, 12.4.1

LONG-to-LOBs, constraints maintained, 12.4.1.1

LONG-to-LOBs, indexing, 12.5.3

migrating to SecureFile LOBs, 4.5

migration of LONG to LOB in parallel, 12.4.3

multibyte character sets, using with the data interface for LOBs, 14.4.3

multithreaded server

BFILEs, 2.7.2, 16.6.7, 16.6.7

N

national language support

NCLOBs, 1.7

NCLOBs

datatype, 1.7

DBMS_LOB, offset and amount parameters in characters, 7.3.2

modify using DBMS_LOB, 7.3.5

NewStreamLob.java, 7.9.23.1

NLS_CHARSET_ID, 7.3.3

NOCOMPRESS, 4.1.1.10, 4.1.8.2

NOCOPY, using to pass temporary LOB parameters by reference, 8.1.4

NOLOGGING, 4.1.1.7

ISNULL usage with LOBs, 10.5.2

NULL LOB value, LOB storage for, 5.3.1

NULL LOB values, LOB storage properties for, 5.3.1

NULL LOB, restrictions calling OCI and DBMS_LOB functions, 5.1.1.1

O

object cache, 6.5

creating an object in, 6.5

LOBs, 6.5

OCCI

compared to other interfaces, 7.2

LOB functionality, 7.5

OCCI Bfile class, 7.5.11

OCCI Blob class

read, 7.5.3

write, 7.5.3

OCCI Clob class, 7.5.1

read, 7.5.3

write, 7.5.3

OCI

available LOB functions, 7.2

character set rules, fixed-width and varying-width, 7.4.3

functions for BFILEs, 7.4.12, 7.5.11

functions for temporary LOBs, 7.4.11, 7.5.11

functions to modify internal LOB values, 7.4.9, 7.5.9

functions to open/close internal and external LOBs, 7.4.15, 7.5.13

functions to read or examine internal and external LOB values, 7.4.10, 7.5.10

LOB buffering example, 6.1.8

LOB locator functions, 7.4.13, 7.5.12

Lob-buffering functions, 7.4.14

NCLOB parameters, 7.4.3.2, 7.5.4.1

OCILobFileGetLength

CLOB and NCLOB input and output length, 7.4.3

OCILobRead2()

varying-width CLOB and NCLOB input and amount amounts, 7.4.3

OCILobWrite2()

varying-width CLOB and NCLOB input and amount amounts, 7.4.3, 7.5.3

offset and amount parameter rules

fixed-width character sets, 7.5.2

setting OCILobRead2(), OCILobWrite2() to OCI_UCS2ID, 7.4.2

using to work LOBs, 7.4

OCI functions on a NULL LOB restriction, 5.1.1.1

OCILobArrayRead(), 15.11

OCILobArrayWrite(), 15.22

OCILobAssign(), 6.1.2

OCILobFileSetName(), 16.5, 16.6.8.3

OCILobFlushBuffer(), 6.1.4

OCILobGetChunkSize(), 6.6.1, 6.6.4

OCILobGetStorageLimit(), 6.6.4

OCILobLoadFromFile(), 16.7, 16.7

OCILobLocator in assignment "=" operations, 7.4.6

OCILobLocator, out-bind variables, 7.4.7

OCILobRead2(), 15.9, 15.10, 16.13

BFILEs, 16.13

OCILobWriteAppend2(), 15.20

OCIObjectFlush(), 16.6.8.3

OCIObjectNew(), 16.6.8.3

OCISetAttr(), 16.6.8.3

ODP.NET, 7.2

offset parameter, in DBMS_LOB operations, 7.3.2

OLEDB, 7.10

OO4O, See Oracle Objects for OLE (OO4O)

open

checking for open BFILEs with FILEISOPEN(), 16.11

checking if BFILE is open with ISOPEN, 16.10

open, determining whether a LOB is open, 15.8

OpenCloseLob.java example, 7.9.19.4

opening

BFILEs using FILEOPEN, 16.9

BFILEs with OPEN, 16.8

opening and closing LOBs

using JDBC, 7.9.16

ORA-17098

empty LOBs and JDBC, 7.9.24

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, 7.2

internal LOB buffering, 7.8.8

methods and properties to access data stored in BLOBs, CLOBs, NCLOBs, and BFILEs, 7.8.4

modifying internal LOBs, 7.8.5

opening/closing external LOBs (BFILEs), 7.8.7

OraBfile example

OraBlob example

OraBlob, OraClob, and OraBfile encapsulate locators, 7.8.2

properties for operating on external LOBs (BFILEs), 7.8.11

properties for operating on LOBs, 7.8.9

reading/examining internal LOB and external LOB (BFile) values, 7.8.6

read-only methods for external LOBs (BFILEs), 7.8.10

syntax reference, 7.8.1

using Clone method to retain locator independent of dynaset, 7.8.2.2

OraclePreparedStatement, See JDBC

OracleResultSet, See JDBC

oracle.sql.BFILE

BFILE-buffering, 7.9.14

JDBC methods to read/examine BFILEs, 7.9.13

oracle.sql.BLOB

for modifying BLOB values, 7.9.7

reading/examining BLOB values, 7.9.8

See JDBC

oracle.sql.BLOBs

BLOB-buffering

oracle.sql.CLOB

CLOB-buffering

JDBC methods to read/examine CLOB values, 7.9.11

modifying CLOB values, 7.9.10

oracle.sql.CLOBs

See JDBC

OraOLEDB, 7.10

out-of-line storage, 5.3.1

P

parallel DML support, 14.3.11

parallel LONG-to-LOB migration, 12.4.3

partitioned index-organized tables

restrictions for LOB columns, 5.7

pattern

check if it exists in BFILE using instr, 16.16

see if it exists IN LOB using (instr)

internal persistent LOBs, 15.14

PCTINCREASE parameter, recommended value for LOBs, 6.7.1

PCTVERSION, 4.1.1.9, 5.3.5, 5.3.5

performance

guidelines

reading/writing large data chunks, 8.1.3

reading/writing large data chunks, temporary LOBs, 8.1.4

PL/SQL, 7.1

and LOBs, semantics changes, 11.1

changing locator-data linkage, 11.3.1

CLOB variables in, 11.3.1

CLOB variables in PL/SQL, 11.3.1

CLOB versus VARCHAR2 comparison, 11.4

CLOBs passed in like VARCHAR2s, 11.3.1

defining a CLOB Variable on a VARCHAR, 11.2

freeing temporary LOBs automatically and manually, 11.3.1

PL/SQL functions, remote, 11.5

PL/SQL packages for SECUREFILE, 4.2

PM schema, 2.5.1

polling, 15.10, 15.20, 16.13

prefetching data, 7.4.1

print_media creation, 9.1

print_media table definition, 2.5.1

Pro*C/C++ precompiler

available LOB functions, 7.2, 7.2

LOB buffering, 7.6.8

locators, 7.6.7

modifying internal LOB values, 7.6.3

opening and closing internal LOBs and external LOBs (BFILEs), 7.6.9

providing an allocated input locator pointer, 7.6.1

reading or examining internal and external LOB values, 7.6.4

statements for BFILEs, 7.6.6

statements for temporary LOBs, 7.6.5

Pro*COBOL precompiler

available LOB functions, 7.2

LOB buffering, 7.7.8

locators, 7.7.7

modifying internal LOB values, 7.7.3

providing an allocated input locator, 7.7.1

reading or examining internal and external LOBs, 7.7.4

statements for BFILEs, 7.7.6

temporary LOBs, 7.7.5

programmatic environments

available functions, 7.2

compared, 7.2

programmatic environments for LOBs, 7.1

R

read consistency

LOBs, 6.3.1

read-consistent locators, 6.1.4, 6.1.7, 6.3, 6.3.1, 6.3.6, 6.4.4

reading

data from a LOB

internal persistent LOBs, 15.10

large data chunks, performance guidelines, 8.1.3

large data chunks, temporary LOBs, 8.1.4

portion of BFILE data using substr, 16.14

portion of LOB using substr

internal persistent LOBs, 15.12

small amounts of data, enable buffering, 15.25

reference semantics, 9.3, 9.3

BFILEs enables multiple BFILE columns for each record, 16.4

remote built-in functions, 10.6

remote PL/SQL functions, 11.5

replication, 12.1

restrictions

binds of more than 4000 bytes, 14.3.10

cannot call OCI or DBMS_LOB functions on a NULL LOB, 5.1.1.1

clustered tables, 12.5.1

indexes, 12.5.3

index-organized tables and LOBs, 5.7

replication, 12.1

triggers, 12.5.2

restrictions, See LOBs

restrictionsrestrictions

on LOBs

RETENTION, 4.1.1.4, 4.1.8.4

retrieving LOB access statistics, 8.3.1

RETURNING clause, using with INSERT to initialize a LOB, 5.1.1.2

round-trips to the server, avoiding, 6.1.1, 6.1.7

rules for using directory objects and BFILEs, 3.3.1

S

sample schema for examples, 9.1

SECUREFILE

ALTER TABLE parameters, 4.1.8

LOB storage parameter, 4.1.1.2

PL/SQL, 4.2

SecureFile

CREATE TABLE parameters, 4.1.1

initialization parameters, 4.3

security

BFILEs, 16.5.1, 16.6

BFILEs using SQL DDL, 16.6.3

BFILEs using SQL DML, 16.6.4

SELECT statement

read consistency, 6.3.1

semantics

copy-based for internal LOBs, 9.3

reference based for BFILEs, 16.4

SESSION_MAX_OPEN_FILES parameter, 3.3.2, 3.3.2

setting

internal LOBs to empty, 5.1.1.2

LOBs to NULL, 5.1.1.1

overrides for NLS_LANG variable

SQL

Character Functions, improved, 10.1

features where LOBs cannot be used, 10.4

SQL DDL

BFILE security, 16.6.3

SQL DML

BFILE security, 16.6.4

SQL functions on LOBs

return type, 10.2.3

return value, 10.2.3

temporary LOBs returned, 10.2.3

SQL semantics and LOBs, 10.4

SQL semantics supported for use with LOBs, 10.2

SQL*Loader

conventional path load, 3.1.1

direct-path load, 3.1.1

statistics, access, 8.3

streaming, 15.9

do not enable buffering, when using, 15.25

write, 15.21

streaming APIs

NewStreamLob.java, 7.9.23.1

using JDBC and BFILEs, 7.9.23

using JDBC and CLOBs, 7.9.22

using JDBC and LOBs, 7.9.21

Streams

SecureFiles not supported, 4.4

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, 15.28.1

temporary LOBs

checking if LOB is temporary, 15.28

DBMS_LOB available functions/procedures, 7.3.7

OCI functions, 7.4.11, 7.5.11

Pro*C/C++ precompiler embedded SQL statements, 7.6.5

Pro*COBOL precompiler statements, 7.7.5

returned from SQL functions, 10.2.3

TO_BLOB(),TO_CHAR(), TO_NCHAR(), 11.3

TO_CHAR(), 11.3

TO_CLOB()

converting VARCHAR2,NVARCHAR2,NCLOB to CLOB, 11.3

TO_NCLOB(), 11.3

transaction boundaries

LOB locators, 6.4

transaction IDs, 6.4.1

transactions

external LOBs do not participate in, 1.5

IDs of locators, 6.4

internal LOBs participate in database transactions, 1.4.1

LOB locators cannot span, 6.4.4

locators with non-serializable, 6.4.1

locators with serializable, 6.4.1

migrating from, 6.1.5

triggers

LONG-to-LOB migration, 12.5.2

trimming

LOB data

internal persistent LOBs, 15.23

trimming LOBs using JDBC, 7.9.20

U

UB8MAXVAL is BFILE maximum size, 6.6

UCS2 Unicode character set

varying width character data, 5.2.2

UNICODE

VARCHAR2 and CLOBs support, 10.2.1

unstructured data, 1.2.2

UPDATE statements

binds of greater than 4000 bytes, 14.3.7

updated locators, 6.1.4, 6.3.3, 6.3.6

updating

avoid the LOB with different locators, 6.3.5

LOB values using one locator, 6.3.5

LOB values, read consistent locators, 6.3.1

LOB with PL/SQL bind variable, 6.3.6

LOBs using SQL and DBMS_LOB, 6.3.4

locators, 6.4.4

locking before, 15.16

locking prior to, 15.2, 15.23, 15.24

V

V$NLS_VALID_VALUES, 7.3.3

VARCHAR2

accessing CLOB data when treated as, 11.2

also RAW, applied to CLOBs and BLOBs, 10.5

defining CLOB variable on, 11.2

VARCHAR2, using SQL functions and operators with LOBs, 10.2

VARRAY

LOB restriction, 2.7.1

varying-width character data, 5.2.2

views on DIRECTORY object, 16.6.5

W

WHERE Clause Usage with LOBs, 10.5.3

writing

data to a LOB

internal persistent LOBs, 15.21

large data chunks, performance guidelines, 8.1.3

large data chunks, temporary LOBs, 8.1.4

singly or piecewise, 15.20

small amounts of data, enable buffering, 15.25