Index

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

A

abstract data types 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

accessing LOBs, 16.1

administrative APIs, 8.2.2

Advanced LOB compression, 4.1.2.1

Advanced LOB Deduplication, 4.1.2.2

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

array read, 22.11

array write, 22.22

assigning OCILobLocator pointers, 13.4.6

ASSM tablespace, 4.1.2, 4.2.1, 4.4.2, 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

BasicFiles LOB Storage, 4.1.1

BasicFiles LOBs and SecureFiles LOBs, 1.10

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

data type, 1.7

DBMS_LOB read-only procedures, 13.3.8

DBMS_LOB, offset and amount parameters in bytes, 13.3.2

locators, 2.5, 2.5

maximum number of open, 3.3.2, 21.18

maximum size, 12.6, 12.6

multithreaded server mode, 2.7.2, 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.8.21

Pro*C/C++ precompiler statements, 13.6.6

Pro*COBOL precompiler embedded SQL statements, 13.7.6

reading with DBMS_LOB, 13.3.6

security, 21.5.1, 21.6

storage devices, 1.4.2

storing any operating system file, 1.7

streaming APIs, 13.8.25

using JDBC to read/examine, 13.8.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-buffering, See JDBC

BLOBs

class, 13.5.1.2, 13.8.2

data type, 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.8.9

using JDBC to read/examine BLOB values, 13.8.10

using oracle.sql.BLOB methods to modify, 13.8.9

body.sql script, 9.3.5

buffering

disable persistent LOBs, 22.27

LOB buffering subsystem, 12.1.3.2

buffering, enable

persistent LOBs, 22.25

buffering, flush

persistent LOBs, 22.26

built-in functions, remote, 16.6

C

C, See OCI

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

CACHE / NOCACHE, 11.3.8

caches

object cache, 12.5

callback, 21.13, 22.10, 22.20

capi.sql script, 9.3.6

CAST, 17.3

catalog views

v$temporary_lobs, 3.2

character data

varying width, 11.2.2

character set ID, 13.3.3, 13.4.2

See CSID parameter

character set ID, getting

persistent LOBs, 22.4

charactersets

multibyte, LONG and LOB datatypes, 20.4.3

CHECKACCESS, 8.2.14

CHUNK, 4.2.1, 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

session collation settings, 16.2.1

CLOB-buffering, See JDBC

CLOBs

class, See JDBC

columns

varying- width character data, 11.2.2

data type, 1.7

datatype

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.8.20

reading/examining with JDBC, 13.8.13

using JDBC to modify, 13.8.12

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.3

comparing

all or parts of two BFILEs, 21.15

comparing, all or part of two LOBs

persistent LOBs, 22.13

COMPRESS, 4.2.1, 4.3.1

compression

Advanced LOB, 4.1.2.1

content store

listing, 8.2.2.5

looking up, 8.2.2.7

registering, 8.2.2.1

unmounting, 8.2.2.4

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

directories, 10.3.2.4

files, 10.3.2.4

LOB locator

persistent LOBs, 22.17

LOB locator for BFILE, 21.19

copying, all or part of a LOB to another LOB

persistent LOBs, 22.16

CREATE TABLE and SecureFiles LOB features, 4.2.2

CREATE TABLE parameters for SecureFiles LOBs, 4.2

CREATE TABLE syntax and notes, 4.2

creating

a directory, 10.3.2.2

partitioned file system, 10.2.4

creating a non-partitioned file system, 10.2.3

creating SecureFiles File System Store, 6.1.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, 18.4.4

SecureFiles LOBs, 3.1.3

Data Pumping

transferring LOB data, 3.1.3

database file system links, 7.4

db_securefile init.ora parameter, 4.4.2

DBFS

administration, 10.4

backing up, 10.4.5

body.sql script, 9.3.5

caching, 10.4.4

capi.sql script, 9.3.6

client, 5.2.1

command-Line interface, 10.3.2

Content SPI (Store Provider Interface), 9.2

content store, 5.3

creating a custom provider, 9.3

creating a custom provider, mechanics, 9.3.1

creating SecureFiles File System Store, 6.1.2

custom provider sample installation and setup, 9.3.1.1

DBFS Server, 5.2.1

diagnostics, 10.4.2

example store provider, 9.3

FTP access, 10.3.5.3

hierachical store, setting up, 7.2

Hierarchical Store Package, DBMS_DBFS_HS, 7.1

hierarchical store, dropping, 7.3.3

hierarchical store, setting up, 7.2.2

hierarchical store, using, 7.3

hierarchical store, using compression, 7.3.4

hierarchical store, using tape, 7.3.5

HS store wallet, setting up, 7.2.1

HTTP access to, 10.3.5.4

internet access, 10.3.5.1

managing client failover, 10.4.3

Online Filesystem Reorganization, 10.5

overview, 5.2

RAC cluster, 10.4.3

reorganizing file systemsDBFS

online redefinition, 10.5

SecureFiles LOB advanced features, 10.4.7

SecureFiles Store

setting up, 6.1

SecureFiles Store File Systems, dropping, 6.2.2

SecureFiles Store File Systems, initializing, 6.1.3

sharing, 10.4.4

shrinking file systems, 10.5

small file performance, 10.4.6

spec.sql script, 9.3.4

store creation, 9.1

TaBleFileSystem Store Provider ("tbfs"), 9.3

TBFS.SQL script, 9.3.2

TBL.SQL script, 9.3.3

using a SecureFiles Store File System, 6.2

using Oracle Wallet, 10.4.1

XDB internet access, 10.3.5.1

DBFS Content API

abstract operations, 8.2.15

access checks, 8.2.14

and stores, 8.2

content IDs, 8.2.1.4

creation operations, 8.2.7

deletion operations, 8.2.8

directory listings, 8.2.11

exceptions, 8.2.1.12

get operations, 8.2.9

getting started, 8.2.1

interface versioning, 8.2.5

lock types, 8.2.1.7

locking operations, 8.2.13

move operations, 8.2.10

navigation, 8.2.12

optional properties, 8.2.1.9

overview, 8.1

path name types, 8.2.1.5

path names, 8.2.6

path normalization, 8.2.16

path properties, 8.2.1.3

property access flags, 8.2.1.11

property bundles, 8.2.1.13

put operations, 8.2.9

rename operations, 8.2.10

role, 8.2.1.1

search, 8.2.12

session defaults, 8.2.4

space usage, 8.2.3

standard properties, 8.2.1.8

statistics support, 8.2.17

store descriptors, 8.2.1.14

store features, 8.2.1.6

structure, properties, 8.2.19

tracing support, 8.2.18

types and constants, 8.2.1.2

user-defined properties, 8.2.1.10

using, 6.2.1

DBFS content store path

creating, 10.3.2.1

DBFS file system

accessing, 10.3

client prerequisites, 10.3.1

creating, 10.2.1

creating a DBFS file system, 10.2

dropping, 10.2.5

partitioned versus non-partitioned, 10.2.2

DBFS installation, 10.1

DBFS links, 7.4

DBFS mounting interface

Linux and Solaris, 10.3.3

DBFS Mounting Interface (Linux Only), 10.3.3

DBFS SecureFiles Store

setting up permissions, 6.1.1

DBFS SecureFiles Store Package, DBMS_DBFS_SFS, 6.3

DBFS SPI (DBMS_DBFS_CONTENT_SPI), 9.1

DBFS Store

mounting, 10.3.3.2

DBMS_DBFS_CONTENT_SPI, 9.1

DBMS_DBFS_HS, 7.1

DBMS_DBFS_HS package, 7.5

methods, 7.5.2

views, 7.6

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

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.8.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

using with SecureFiles and DBFS, 4.6.1

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.5

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.WRITE()

passing hexadecimal string to, 22.21

DBMS_REDEFINITION package, 4.3

DBMS_SPACE package, 4.6.2

DECRYPT, 4.2.1, 4.3.1

DEDUPLICATE, 4.2.1, 4.3.1

deduplication

Advanced LOB, 4.1.2.2

diagnostics

DBFS, 10.4.2

directories

catalog views, 21.6.5

creating, 10.3.2.2

guidelines for usage, 21.6.6

listing, 10.3.2.3

ownership and privileges, 21.6.1

DIRECTORY object, 21.3

catalog views, 21.6.5

getting the alias and filename, 21.20

guidelines for usage, 21.6.6

name specification, 21.5.1

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

symbolic links, and, 3.3

direct-path load, 3.1.1

DISABLE STORAGE IN ROW, 11.3.1

displaying

LOB data for 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.8.26

JDBC, 13.8.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, 4.3.1

encryption

SecureFiles, 4.1.2.3

equal, one LOB locator to another

persistent LOBs, 22.18

erasing, part of LOB

persistent LOBs, 22.24

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

examples, LOB access statistics, 14.3.1

existence

check for BFILE, 21.17

extensible indexes, 11.4.3

external callout, 12.1.5

external LOBs (BFILEs), 1.4.2

See BFILEs

external LOBs (BFILEs), See BFILEs

F

file system

links, 7.4

security model, 10.3.4

FILECLOSEALL(), 21.6.6

FILESYSTEM_LIKE_LOGGING, 4.2.1

flushing

buffer, 12.1.1

LOB buffer, 12.1.4

FOR UPDATE clause

LOB locator, 12.3.1

FREELIST GROUPS, 4.2.1

FREELISTS, 4.2.1

FREEPOOLS, 4.2.1, 4.2.1

FTP

access to DBFS, 10.3.5

function-based indexes, 11.4.3

on LOB columns, 11.4.3

FUSE

installing, 10.3.3.1

G

getting started with DBFS Content API, 8.2.1

getting started with DBMS_DBFS_CONTENT, 8.2.1

H

hexadecimal string

passing to DBMS_LOB.WRITE(), 22.21

hierarchical store

dropping, 7.3.3

setting up, 7.2.2

using, 7.3

using compression, 7.3.4

using tape, 7.3.5

Hierarchical Store Package, DBMS_DBFS_HS, 7.1

HS store wallet, 7.2.1

HTTP

access to DBFS, 10.3.5

HTTP access to DBFS, 10.3.5.4

I

implicit assignment and parameter passing for LOB columns, 20.3.2

implicit conversion of CLOB to character type, 16.2

improved LOB usability, 16.1

indexes

function-based, 11.4.3

rebuilding after LONG-to-LOB migration, 18.5.3

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

index-organized tables, restrictions for LOB columns, 11.7

Information Lifecycle Management (ILM), 7.1

INITFS, 6.1.3

initialization parameters for SecureFiles LOBs, 4.4.2

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.4.2

inline storage, 11.3.1

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

FUSE, 10.3.3.1

Oracle Database, 10.1

interfaces for LOBs, see programmatic environments

ioctl, 10.3.3.6

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.8.1

java.sql.Clob, 13.8.1

JDBC

available LOB methods/properties, 13.2

BFILE class

BFILE streaming APIs, 13.8.25

BFILE-buffering, 13.8.16

BLOB and CLOB classes

calling DBMS_LOB package, 13.8.3

checking if BLOB is temporary, 22.28.1

CLOB streaming APIs, 13.8.24

empty LOBs, 13.8.26

encapsulating locators, 13.8.2

methods/properties for BLOB-buffering, 13.8.11

methods/properties for CLOBs

buffering, 13.8.14

modifying BLOB values, 13.8.9

modifying CLOB values, 13.8.12

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

newStreamLob.java, 13.8.25.1

opening and closing BFILEs, 13.8.21

opening and closing CLOBs, 13.8.20

opening and closing LOBs, 13.8.18

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

reading/examining BLOB values, 13.8.10

reading/examining CLOB values, 13.8.13

reading/examining external LOB (BFILE) values, 13.8.15

referencing LOBs, 13.8.6

streaming APIs for LOBs, 13.8.23

syntax references, 13.8.7

trimming LOBs, 13.8.22

using OracleResultSet to reference LOBs, 13.8.6.1

using OUT parameter from OraclePreparedStatement to reference LOBs, 13.8.6.1

writing to empty LOBs, 13.8.26

JDBC 3.0, 13.8.1

JDBC and Empty LOBs, 13.8.26

K

KEEP_DUPLICATES, 4.2.1, 4.3.1

L

LBS, See Lob Buffering Subsystem (LBS)

length

getting BFILE, 21.18

persistent LOB, 22.15

LENGTH return value for LOBs, 16.2.5

libaio

asynchronous I/O through, 10.3.3.6

Linux

DBFS mounting interface, 10.3.3

listing

a directory, 10.3.2.3

a LOB with BFILE data, 21.7

LOB with data from a BFILE, 22.5

loading BEFILEs

using SQL*Loader, 3.1.2

loading data into LOBs

utilities, 3.1

LOB attributes

defined, 1.8

LOB buffering

BLOB-buffering with JDBC, 13.8.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

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)

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 Buffering SubSystem (LBS), 12.1

LOB column cells

accessing, 2.1

LOB column states, 2.1

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

LOB locators, always stored in row, 11.3.1

LOB prefetching

JDBC, 13.8.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 data types, members of, 1.8

accesing with SQL, 2.6.1

accessing, 2.6

accessing using the data interface, 2.6.2

accessing using the locator interface, 2.6.3

attributes and abstract data types, 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

changing default tablespace storage, 3.4

data types 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.2

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

locators, 2.5

locking before updating, 22.2, 22.16, 22.20, 22.21, 22.23, 22.24

LOGGING / NOLOGGING, 11.3.9

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

loading data into, using SQL*Loader, 3.1.1

locator, 2.4

locators, 2.5, 12.3.1

locking rows, 2.2

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

value, 2.4

varying-width character data, 11.2.3

LOBS

opening and closing, 2.3

LOBs, data interface for remote, 20.6

LOBs, data interface in Java, 20.5

locators, 2.5

BFILE guidelines, 21.6.8.3

BFILEs, 21.6.8

BFILEs, two rows can refer to the same file, 21.6.8.1

buffer-enabled, 12.1.6

external LOBs (BFILEs), 2.5

LOB, 1.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

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

locators, see if LOB locator is initialized

persistent LOBs, 22.19

locking, 10.3.3.6

locking a row containing a LOB, 2.2

LOGGING, 4.2.1

migrating LONG-to-LOBs, 18.2.2

LOGGING / NOLOGGING, 11.3.9

LONG versus LOB data types, 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

migrating

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.5, 4.5.3

migration of LONG to LOB in parallel, 18.4.3

mount points

listing, 8.2.2.6

mounted file systems

restrictions, 10.3.3.6

mounting

DBFS through fstab for Linux, 10.3.3.4

DBFS through fstab for Solaris, 10.3.3.5

the DBFS store, 10.3.3.2

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

NCLOB

session collation settings, 16.2.1

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.8.25.1

NLS_CHARSET_ID, 13.3.3

NOCOMPRESS, 4.2.1, 4.3.1

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

NOLOGGING, 4.2.1

non-partitioned file system

creating, 10.2.3

NORMALIZEPATH, 8.2.16

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.9

Online Filesystem Reorganization, 10.5

online redefinition

DBFS, 10.5

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.8.21.4

opening

BFILEs using FILEOPEN, 21.9

BFILEs with OPEN, 21.8

opening and closing LOBs, 2.3

using JDBC, 13.8.18

ORA-17098

empty LOBs and JDBC, 13.8.26

ORA-22992, 2.7.1

Oracle Call Interface, See OCI

Oracle Database Installation, 10.1

OraclePreparedStatement, See JDBC

OracleResultSet, See JDBC

oracle.sql.BFILE

BFILE-buffering, 13.8.16

JDBC methods to read/examine BFILEs, 13.8.15

oracle.sql.BLOB

for modifying BLOB values, 13.8.9

reading/examining BLOB values, 13.8.10

See JDBC

oracle.sql.BLOBs

BLOB-buffering

oracle.sql.CLOB

CLOBs

buffering

JDBC methods to read/examine CLOB values, 13.8.13

modifying CLOB values, 13.8.12

oracle.sql.CLOBs

See JDBC

OraOLEDB, 13.9

out-of-line storage, 11.3.1

P

parallel DML support, 20.3.11

parallel LONG-to-LOB migration, 18.4.3

Parallel Online Redefinition, 4.5.4

partitioned DBFS file system

versus non-partitioned, 10.2.2

partitioned file system

creating, 10.2.4

partitioned index-organized tables

restrictions for LOB columns, 11.7

pattern

check if it exists in BFILE using instr, 21.16

pattern, if it exists IN LOB using (instr)

persistent LOBs, 22.14

PCTINCREASE parameter, recommended value for LOBs, 12.7.1

PCTVERSION, 4.2.1, 11.3.5, 11.3.5

performance

guidelines

reading/writing large data chunks, temporary LOBs, 14.1.4

performance guidelines, 14.1.3

reading/writing large data chunks, 14.1.3

persistent LOBs, 22.20, 22.21

pipes, 10.3.3.6

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

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.4

PL/SQL packages for SecureFiles LOB, 4.6

PM schema, 2.5.1

polling, 21.13, 22.10, 22.20

prefetching data, 13.4.1

prerequisites

DBFS file system client, 10.3.1

print_media creation, 15.1

print_media table definition, 2.5.1

privileges

to create DBFS file system, 10.2.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

Q

Query APIs, 8.2.2

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

large data chunks, 14.1.3

large data chunks, temporary LOBs, 14.1.4

portion of BFILE data using substr, 21.14

small amounts of data, enable buffering, 22.25

reading, data from a LOB

persistent LOBs, 22.10

reading, portion of LOB using substr

persistent LOBs, 22.12

reference semantics, 15.3, 15.3

BFILEs enables multiple BFILE columns for each record, 21.4

registered store

mounting, 8.2.2.3

unregistering, 8.2.2.2

remote built-in functions, 16.6

remote LOBs, 2.7.1

remote PL/SQL functions, 17.4

removing

directories, 10.3.2.5

files, 10.3.2.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

restrictions on mounted file systems, 10.3.3.6

restrictions on remote LOBs, 2.7.1

RETENTION, 4.2.1, 4.3.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

S

Samba, 10.3.3.6

sample schema for examples, 15.1

SECUREFILE

ALTER TABLE parameters, 4.3

LOB storage parameter, 4.2.1

SecureFiles Encryption, 4.1.2.3

SecureFiles LOB

CREATE TABLE parameter, 4.2

PL/SQL, 4.6

SecureFiles LOB Storage, 4.1.2

SecureFiles LOBs

initialization parameters, 4.4.2

SecureFiles LOBs and BasicFiles LOBs, 1.10

SecureFiles Store

setting up, 6.1

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

copying and referencing, 1.6

for internal and external LOBs, 1.6

reference based for BFILEs, 21.4

semistructured data, 1.2

session collation settings

CLOB and NCLOB, 16.2.1

SESSION_MAX_OPEN_FILES parameter, 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

simple structured data, complex structured data, 1.2

Solaris

mounting interface, 10.3.3

Solaris-Specific privileges, 10.3.3.2

Solaris 11 SRU7

installing FUSE, 10.3.3.1

spec.sql script, 9.3.4

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.4

return value, 16.2.4

temporary LOBs returned, 16.2.4

SQL semantics and LOBs, 16.4

SQL semantics supported for use with LOBs, 16.2

SQL*Loader, 3.1.2

conventional path load, 3.1.1

direct-path load, 3.1.1

LOBs

loading data into, 3.1.1

statistics, access, 14.3

streaming, 22.9

do not enable buffering, when using, 22.25

write, 22.21

streaming APIs

NewStreamLob.java, 13.8.25.1

using JDBC and BFILEs, 13.8.25

using JDBC and CLOBs, 13.8.24

using JDBC and LOBs, 13.8.23

symbolic links, rules with DIRECTORY objects and BFILEs, 3.3

system owned object, See DIRECTORY object

T

TaBleFileSystem Store Provider ("tbfs"), 9.3

tablespace storage

changing, 3.4

TBFS.SQL script, 9.3.2

TBL.SQL script, 9.3.3

TDE, 4.1.2.3

temporary BLOB

checking if temporary using JDBC, 22.28.1

temporary LOBs, 3.2

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.4

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

transferring LOB data, 3.1.3

Transparent Data Encryption (TDE), 4.1.2.3

transparent read, 7.4.6

triggers

LONG-to-LOB migration, 18.5.2

trimming LOB data

persistent LOBs, 22.23

trimming LOBs using JDBC, 13.8.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.2

unmounting

a file system, 10.3.3.3

unstructured data, 1.2, 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

using SQL character functions, 16.1

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

VARRAYs

stored as LOBs, 1.9.1

varying-width character data, 11.2.2

views on DIRECTORY object, 21.6.5

W

wallet

HS store wallet, 7.2.1

Wallet,Oracle, 10.4.1

WebDAV

access to DBFS, 10.3.5

WHERE Clause Usage with LOBs, 16.5.3

writing

data to a LOB, 22.21

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.8.5