Oracle 8i Application Developer's Guide - Large Objects (LOBs)
Release 8.1.5
A68004-01

Index

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

B

BFILE datatype, 1-3

BFILENAME(), 5-5

initializing, 5-5

maximum number of open, 1-8, 5-136

multi-threaded server (MTS), 5-10

BLOB datatype, 1-2

buffers

C

CACHE / NOCACHE, 3-10

caches

object cache, 2-14

CLOB datatype, 1-2

copy semantics for internal LOBs, 3-28

copying LOBs, 2-12

D

DBMS_LOB package

multi-threaded server (MTS), 5-10

deleting internal LOBs, 2-14

deleting LOBs, 2-14

directories

catalog views, 5-9

guidelines for usage, 5-9

ownership and privileges, 5-7

DIRECTORY name specification, 5-7

directory objects, 5-5

E

examples

LOB buffering, 2-21

read consistent locators, 2-3

repercussions of mixing SQL DML with DBMS_LOB, 2-6

updated LOB locators, 2-8

updating a LOB with a PL/SQL variable, 2-10

external callout, 2-20

external LOBs (BFILEs), 1-2

F

flushing the LOB's buffer, 2-15

FOR UPDATE clause

LOBs, 1-49, 2-2

L

LBS

SeeLOB Buffering Subsystem

LOB Buffering System (LBS)

LOB locators cannot span transactions, 1-49

LOBS

external (BFILEs), 1-2

LOBs

accessing through a locator, 1-49

buffering

pages can be aged out, 2-19

buffering operations, 2-17

buffering subsystem, 2-14

in partitioned tables, 6-2

in the object cache, 2-14

inline storage, 1-47

internal LOBs

CACHE / NOCACHE, 3-10

ENABLE | DISABLE STORAGE IN ROW, 3-12

initializing, 5-93

locking before updating, 3-146, 3-182, 3-192, 3-201, 3-217, 3-227

LOGGING / NOLOGGING, 3-10

PCTVERSION, 3-9

setting to empty, 3-8

tablespace and LOB index, 3-9

tablespace and storage characteristics, 3-8

LOB locators, 2-2

object cache, 2-14

performance, best practices, 2-24

performing SELECT on, 1-49

piecewise operations, 2-5

read consistent locators, 2-2

setting to contain a locator, 1-47

setting to NULL, 3-7

tables

adding partitions, 6-6

creating indexes, 6-5

exchanging partitions, 6-5

merging partitions, 6-6

moving partitions, 6-6

partitioning, 6-3

splitting partitions, 6-6

typical uses, 1-39

updated LOB locators, 2-5

varying-width character data, 2-25

accessing a LOB through, 1-49

cannot span transactions, 1-49

read consistent, 2-2, 2-3, 2-9, 2-12, 2-19, 2-21, 2-22, 2-24

read consistent locators, 2-2

selecting, 1-49

setting column / attribute to contain, 1-47

updated, 2-2, 2-5, 2-10, 2-12, 2-19

LOGGING / NOLOGGING, 3-10

M

multi-threaded server (MTS)

N

national language support

NCLOB datatype, 1-2

O

object cache, 2-14

P

PCTVERSION, 3-9

R

read consistency

read consistent locators, 2-2, 2-3, 2-9, 2-12, 2-19, 2-21, 2-22, 2-24

reference semantics for BFILEs, 5-6

roundtrips to the server, avoiding, 2-15, 2-21

S

SELECT command

FOR UPDATE, 1-49

read consistency, 2-2

semantics

copy-based for internal LOBs, 3-28

reference based for BFILEs, 5-6

SESSION_MAX_OPEN_FILES parameter, 1-8, 5-52, 5-67

setting internal LOBs to empty, 3-8

setting LOBs to NULL, 3-7

SQL DDL

BFILE security, 5-8

SQL DML

BFILE security, 5-8

T

transactions

external LOBs do not participate, 1-3

internal LOBs participate fully, 1-2

LOB locators cannot span, 1-49

migrating from, 2-20

U

updated locators, 2-2, 2-5, 2-10, 2-12, 2-19

V

value of LOBs, 1-47

Copyright © 1999 Oracle Corporation.
All Rights Reserved.