1. Index

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

  • accessing a LOB
    • using the LOB APIs 2.6.3
  • accessing external LOBs 11.2
  • accessing LOBs 7.1
  • access statistics for LOBs 15.3
  • administrative APIs 23.4
  • Advanced LOB compression 3.1.2.1
  • Advanced LOB Deduplication 3.1.2.2
  • ALTER TABLE parameters for SecureFiles LOBs 3.3
  • amount 11.13
  • amount parameter
    • used with BFILEs 11.7
  • appending
    • writing to the end of a LOB 12.20
  • array read 12.11
  • array write 12.22
  • assigning OCILobLocator pointers 10.4.6
  • ASSM tablespace 3.1.2, 3.2.1, 3.4.2, 13.3.6, 17.4.4
  • available LOB methods 10.2

B

  • BASICFILE
    • LOB storage parameter 3.2.1
  • BasicFiles LOBs and SecureFiles LOBs 1.10
  • BasicFiles LOB Storage 3.1.1
  • BFILE-buffering, See JDBC 10.8.16
  • BFILE class, See JDBC 10.8.2
  • BFILENAME function 2.5.2.2, 11.4
  • BFILEs 1.4.2
    • accessing 11.2
    • converting to CLOB or NCLOB 11.7
    • creating an object in object cache 14.5
    • DBMS_LOB, offset and amount parameters in bytes 10.3.2
    • DBMS_LOB read-only procedures 10.3.8
    • locators 2.5
    • maximum number of open 11.18, 16.3.2
    • maximum size 14.6
    • multithreaded server mode 2.7.2, 11.6.7
    • not affected by LOB storage properties 13.3.1
    • OCI functions to read/examine values 10.4.10, 10.5.10
    • OCI read-only functions 10.4.12, 10.5.11
    • opening and closing using JDBC 10.8.21
    • Pro*C/C++ precompiler statements 10.6.6
    • Pro*COBOL precompiler embedded SQL statements 10.7.6
    • reading with DBMS_LOB 10.3.6
    • security 11.6
    • storage devices 1.4.2
    • streaming APIs 10.8.25
    • using JDBC to read/examine 10.8.15
    • using Pro*C/C++ precompiler to open and close 10.6.9
  • binds
    • See also INSERT statements and UPDATE statements 9.3.8
  • bind variables, used with LOB locators in OCI 10.4.7
  • BLOB-buffering, See JDBC 10.8.11
  • BLOBs
    • class 10.5.1.2, 10.8.2
    • DBMS_LOB, offset and amount parameters in bytes 10.3.2
    • maximum size 14.6
    • modify using DBMS_LOB 10.3.5
    • using JDBC to modify 10.8.9
    • using JDBC to read/examine BLOB values 10.8.10
    • using oracle.sql.BLOB methods to modify 10.8.9
  • body.sql script 24.3.5
  • buffering
  • buffering, enable
  • buffering, flush
  • built-in functions, remote 5.2.1

C

  • C, See OCI 10.1
  • C++, See Pro*C/C++ precompiler 10.1
  • CACHE / NOCACHE 13.3.8
  • caches
  • callback 11.13, 12.10, 12.20
  • capi.sql script 24.3.6
  • catalog views
    • v$temporary_lobs 16.2
  • character data
  • character set ID 10.3.3, 10.4.2
  • character set ID, getting
    • persistent LOBs 12.4
  • charactersets
    • multibyte, LONG and LOB datatypes 9.4.3
  • CHECKACCESS 23.16
  • CHUNK 3.2.1, 13.3.11
  • chunk size 12.21
    • and LOB storage properties 13.3.1
    • multiple of, to improve performance 12.10
  • CLOB
    • session collation settings 7.2.3
  • CLOB-buffering, See JDBC 10.8.14
  • CLOBs
    • class, See JDBC 10.8.2
    • columns
      • varying- width character data 13.2.2
    • datatype
      • varying-width columns 13.2.2
    • DBMS_LOB, offset and amount parameters in characters 10.3.2
    • modify using DBMS_LOB 10.3.5
    • opening and closing using JDBC 10.8.20
    • reading/examining with JDBC 10.8.13
    • using JDBC to modify 10.8.12
  • closing
    • all open BFILEs 11.24
    • BFILEs with CLOSE 11.23
    • BFILEs with FILECLOSE 11.22
  • clustered tables 17.5.2
  • COBOL, See Pro*COBOL precompiler 10.1
  • codepoint semantics 7.2.5
  • comparing
    • all or parts of two BFILEs 11.15
  • comparing, all or part of two LOBs
  • COMPRESS 3.2.1, 3.3.3
  • compression
  • content store
  • conventional path load 16.1.1
  • conversion
    • explicit functions for PL/SQL 8.3
  • conversion, implicit from CLOB to character type 7.2.2
  • conversions
    • character set 11.7
    • from binary data to character set 11.7
    • implicit, between CLOB and VARCHAR2 8.2
  • converting
  • copying
  • copying, all or part of a LOB to another LOB
  • copy semantics 1.6
    • internal LOBs 6.3
  • CREATE TABLE and SecureFiles LOB features 3.2.2
  • CREATE TABLE parameters for SecureFiles LOBs 3.2
  • CREATE TABLE syntax and notes 3.2
  • creating
  • creating a non-partitioned file system 25.2.3
  • creating SecureFiles File System Store 21.1.3
  • CSID parameter
    • setting OCILobRead and OCILobWrite to OCI_UCS2ID 10.4.2

D

  • database file system links 22.5
  • data interface for persistent LOBs 9, 17.5
    • multibyte charactersets 9.4.3
  • data interface for remote LOBs 9.6
  • data interface in Java 9.5
  • Data Pump 17.4.5
  • Data Pumping
    • transferring LOB data 16.1.3
  • db_securefile init.ora parameter 3.4.2
  • DBFS
    • administration 25.4
    • backing up 25.4.5
    • body.sql script 24.3.5
    • caching 25.4.4
    • capi.sql script 24.3.6
    • client 20.2.2
    • command-Line interface 25.3.2
    • Content SPI (Store Provider Interface) 24.2
    • content store 20.3
    • creating a custom provider 24.3
    • creating a custom provider, mechanics 24.3.1
    • creating SecureFiles File System Store 21.1.3
    • custom provider sample installation and setup 24.3.1.1
    • DBFS Server 20.2.2
    • diagnostics 25.4.2
    • example store provider 24.3
    • FTP access 25.3.5.3
    • hierachical store, setting up 22.3
    • hierarchical store, dropping 22.4.3
    • hierarchical store, setting up 22.3.2
    • hierarchical store, using 22.4
    • hierarchical store, using compression 22.4.4
    • hierarchical store, using tape 22.4.5
    • Hierarchical Store Package, DBMS_DBFS_HS 22.1
    • HS store wallet, setting up 22.3.1
    • HTTP access to 25.3.5.4
    • internet access 25.3.5.1
    • managing client failover 25.4.3
    • Online Filesystem Reorganization 25.5
    • overview 20.2
    • RAC cluster 25.4.3
    • reorganizing file systemsDBFS
      • online redefinition 25.5
    • SecureFiles LOB advanced features 25.4.7
    • SecureFiles Store
    • SecureFiles Store File Systems, dropping 21.2.2
    • SecureFiles Store File Systems, initializing 21.1.5
    • sharing 25.4.4
    • shrinking file systems 25.5
    • small file performance 25.4.6
    • spec.sql script 24.3.4
    • store creation 24.1
    • TaBleFileSystem Store Provider ("tbfs") 24.3
    • TBFS.SQL script 24.3.2
    • TBL.SQL script 24.3.3
    • using a SecureFiles Store File System 21.2
    • using Oracle Wallet 25.4.1
    • XDB internet access 25.3.5.1
  • DBFS Content API
  • DBFS content store path
  • DBFS file system
  • DBFS installation 25.1
  • DBFS links 22.5
  • DBFS mounting interface
  • DBFS Mounting Interface (Linux Only) 25.3.3
  • DBFS SecureFiles Store
    • setting up permissions 21.1.1
  • DBFS SecureFiles Store Package, DBMS_DBFS_SFS 21.3
  • DBFS SPI (DBMS_DBFS_CONTENT_SPI) 24.1
  • DBFS Store
  • DBMS_DBFS_CONTENT_SPI 24.1
  • DBMS_DBFS_HS 22.1
  • DBMS_DBFS_HS package 22.6
  • DBMS_LOB
    • deleting LOB with bind variable 14.3.7
    • updating LOB with bind variable 14.3.6
  • DBMS_LOB.GET_STORAGE_LIMIT 14.6.4
  • DBMS_LOB.GETCHUNKSIZE 14.6.2
  • DBMS_LOB.GETLENGTH return value 7.2.7
  • DBMS_LOB.LOADCLOBFROMFILE 10.3.2
  • DBMS_LOB.WRITE()
    • passing hexadecimal string to 12.21
  • DBMS_LOB functions on a NULL LOB restriction 13.1.1.1
  • DBMS_LOB package
    • available LOB procedures/functions 10.2
    • for temporary LOBs 10.3.7
    • functions/procedures to modify BLOB, CLOB, and NCLOB 10.3.5
    • functions/procedures to read/examine internal and external LOBs 10.3.6
    • multithreaded server 2.7.2
    • multithreaded server mode 11.6.7
    • offset and amount parameter guidelines 10.3.2
    • open and close, JDBC replacements for 10.8.18
    • opening/closing internal and external LOBs 10.3.9
    • provide LOB locator before invoking 10.3.1
    • read-only functions/procedures for BFILEs 10.3.8
    • to work with LOBs, using 10.3
    • using with SecureFiles and DBFS 3.6.1
    • WRITE()
  • DBMS_REDEFINITION package 3.3
  • DBMS_SPACE package 3.6.4
  • DECRYPT 3.2.1, 3.3.3
  • DEDUPLICATE 3.2.1, 3.3.3
  • deduplication
  • deleting
    • LOB with PL/SQL bind variable 14.3.7
  • deleting a LOB 14.3.7
  • diagnostics
  • directories
  • DIRECTORY object 11.3
    • catalog views 11.6.5
    • getting the alias and filename 11.20
    • guidelines for usage 11.6.6
    • names on Windows platforms 11.5.1.1
    • name specification 11.5.1
    • READ permission on object not individual files 11.6.2
    • rules for using 16.3
    • symbolic links, and 16.3
  • direct-path load 16.1.1
  • DISABLE STORAGE IN ROW 13.3.1
  • displaying
    • LOB data for persistent LOBs 12.9
  • domain indexing on LOB columns 13.4.1

E

  • embedded SQL statements, See Pro*C/C++ precompiler and Pro*COBOL precompiler 10.6.3
  • EMPTY_BLOB() and EMPTY_CLOB, LOB storage properties for 13.3.1
  • EMPTY_CLOB()/BLOB()
    • to initialize internal LOB 2.5.2.1
  • empty LOBs
  • ENABLE STORAGE IN ROW 13.3.1
  • ENCRYPT 3.2.1, 3.3.3
  • encryption
  • equal, one LOB locator to another
  • erasing, part of LOB
  • examples
    • deleting a LOB with a PL/SQL variable 14.3.7
    • repercussions of mixing SQL DML with DBMS_LOB 14.3.4
    • updated LOB locators 14.3.5
    • updating a LOB with a PL/SQL variable 14.3.6
  • examples, LOB access statistics 15.3.1
  • existence
  • extensible indexes 13.4.3
  • external callout 14.1.6
  • external LOBs (BFILEs) 1.4.2
  • external LOBs (BFILEs), See BFILEs 1.4.2

F

G

  • getting started with DBFS Content API 23.3
  • getting started with DBMS_DBFS_CONTENT 23.3

H

  • hexadecimal string
    • passing to DBMS_LOB.WRITE() 12.21
  • hierarchical store
  • Hierarchical Store Package, DBMS_DBFS_HS 22.1
  • HS store wallet 22.3.1
  • HTTP
  • HTTP access to DBFS 25.3.5.4

I

  • implicit assignment and parameter passing for LOB columns 9.3.3
  • implicit conversion of CLOB to character type 7.2.2
  • improved LOB usability 7.1
  • indexes
  • indexes on LOB columns
  • index-organized tables, restrictions for LOB columns 13.7
  • Information Lifecycle Management (ILM) 22.1
  • init.ora parameter db_securefile 3.4.2
  • INITFS 21.1.5
  • initialization parameters for SecureFiles LOBs 3.4.2
  • initializing
    • during CREATE TABLE or INSERT 6.4
    • using EMPTY_CLOB(), EMPTY_BLOB() 2.5.2.1
  • initializing a LOB column to a non-NULLvalue 13.1.1.2
  • inline storage 13.3.1
  • inserting
    • a row by initializing a LOB locator
      • internal persistent LOBs 6.5
    • a row by initializing BFILE locator 11.25
  • INSERT statements
    • binds of greater than 4000 bytes 9.3.8
  • installing
  • interfaces for LOBs, see programmatic environments 10.2
  • ioctl 25.3.3.11
  • IS NULL return value for LOBs 7.5.3
  • ISNULL usage with LOBs 7.5.3
  • IS NULL usage with LOBs 7.5.3

J

  • Java, See JDBC 10.1
  • JDBC
    • available LOB methods/properties 10.2
    • BFILE-buffering 10.8.16
    • BFILE class 10.8.2
    • BFILE streaming APIs 10.8.25
    • BLOB and CLOB classes 10.8.2
    • calling DBMS_LOB package 10.8.3
    • checking if BLOB is temporary 12.28.1
    • CLOB streaming APIs 10.8.24
    • empty LOBs 10.8.26
    • encapsulating locators 10.8.2
    • methods/properties for BLOB-buffering 10.8.11
    • methods/properties for CLOBs
    • modifying BLOB values 10.8.9
    • modifying CLOB values 10.8.12
    • modifyng internal LOBs with Java using oracle.sql.BLOB/CLOB 10.8.1
    • newStreamLob.java 10.8.25.1
    • opening and closing BFILEs 10.8.21
    • opening and closing CLOBs 10.8.20
    • opening and closing LOBs 10.8.18
    • reading/examining BLOB values 10.8.10
    • reading/examining CLOB values 10.8.13
    • reading/examining external LOB (BFILE) values 10.8.15
    • reading internal LOBs and external LOBs (BFILEs) with Java 10.8.2
    • referencing LOBs 10.8.6
    • streaming APIs for LOBs 10.8.23
    • syntax references 10.8.7
    • trimming LOBs 10.8.22
    • using OracleResultSet to reference LOBs 10.8.6.1
    • using OUT parameter from OraclePreparedStatement to reference LOBs 10.8.6.1
    • writing to empty LOBs 10.8.26
  • JDBC 3.0 10.8.1
  • JDBC and Empty LOBs 10.8.26

K

L

  • LBS, See Lob Buffering Subsystem (LBS) 14.1
  • length
  • LENGTH return value for LOBs 7.2.7
  • libaio
  • Linux
    • DBFS mounting interface 25.3.3
  • listing
  • loading
    • a LOB with BFILE data 11.7
    • LOB with data from a BFILE 12.5
  • loading BEFILEs
  • loading data into LOBs
  • LOB buffering
  • LOB Buffering Subsystem (LBS)
  • LOB Buffering SubSystem (LBS) 14.1
  • LOB column cells
    • accessing 2.1
  • LOB columns
    • initializing to contain locator 2.5.2
    • initializing to NULL or Empty 13.1.1
  • LOB column states 2.1
  • LOB locator
    • copy semantics 1.6
    • external LOBs (BFILEs) 1.6
    • internal LOBs 1.6
    • out-bind variables in OCI 10.4.7
    • reference semantics 1.6
  • LOB locators 1.5
  • LOB locators, always stored in row 13.3.1
  • LOB prefetching
  • LOB reads 15.3
  • LOB restrictions 2.7
  • LOBs
  • LOBS
    • opening and closing 2.3
  • LOBs, data interface for remote 9.6
  • LOBs, data interface in Java 9.5
  • LOB storage
    • format of varying width character data 13.2.2
    • inline and out-of-line storage properties 13.3.1
  • LOB writes 15.3
  • LOB writes unaligned 15.3
  • locators 2.5
  • locators, see if LOB locator is initialized
  • locking 25.3.3.11
  • locking a row containing a LOB 2.2
  • LOGGING
    • LOB storage parameter 3.2.1
    • migrating LONG-to-LOBs 17.2.2
  • LOGGING / NOLOGGING 13.3.9
  • LONG-to-LOB migration
  • LONG versus LOB data types 1.3

M

  • MAXSIZE 3.2.1
  • migrating
    • LONG-to-LOBs, constraints maintained 17.4.1
    • LONG-to-LOBs, indexing 17.5.4
    • LONG to LOBs, see LONG-to-LOB 17.1
    • LONG-to-LOB using ALTER TABLE 17.4.2
  • migrating to SecureFiles LOBs 3.5, 3.5.3
  • migration of LONG to LOB in parallel 17.4.4
  • mounted file systems
  • mounting
  • mount points
  • multibyte character sets, using with the data interface for LOBs 9.4.3
  • multithreaded server

N

  • NCLOB
    • session collation settings 7.2.3
  • NCLOBs
    • DBMS_LOB, offset and amount parameters in characters 10.3.2
    • modify using DBMS_LOB 10.3.5
  • NewStreamLob.java 10.8.25.1
  • NOCOMPRESS 3.2.1, 3.3.3
  • NOCOPY, using to pass temporary LOB parameters by reference 15.1.4
  • NOLOGGING
    • LOB storage parameter 3.2.1
  • non-partitioned file system
  • NORMALIZEPATH 23.18
  • NULL LOB, restrictions calling OCI and DBMS_LOB functions 13.1.1.1
  • NULL LOB value, LOB storage for 13.3.1
  • NULL LOB values, LOB storage properties for 13.3.1

O

  • object cache 14.5
  • OCCI
    • compared to other interfaces 10.2
    • LOB functionality 10.5
  • OCCI Blob class
  • OCCI Clob class
  • OCI
    • available LOB functions 10.2
    • character set rules, fixed-width and varying-width 10.4.3
    • functions for BFILEs 10.4.12, 10.5.11
    • functions for temporary LOBs 10.4.11, 10.5.11
    • functions to modify internal LOB values 10.4.9, 10.5.9
    • functions to open/close internal and external LOBs 10.4.15, 10.5.13
    • functions to read or examine internal and external LOB values 10.4.10, 10.5.10
    • LOB buffering example 14.1.10
    • Lob-buffering functions 10.4.14
    • LOB locator functions 10.4.13, 10.5.12
    • NCLOB parameters 10.4.3.2, 10.5.4.1
    • OCILobFileGetLength
      • CLOB and NCLOB input and output length 10.4.3
    • OCILobRead2()
      • varying-width CLOB and NCLOB input and amount amounts 10.4.3
    • OCILobWrite2()
      • varying-width CLOB and NCLOB input and amount amounts 10.4.3, 10.5.3
    • offset and amount parameter rules
      • fixed-width character sets 10.5.2
    • setting OCILobRead2(), OCILobWrite2() to OCI_UCS2ID 10.4.2
    • using to work LOBs 10.4
  • OCI functions on a NULL LOB restriction 13.1.1.1
  • OCILobArrayRead() 12.11
  • OCILobArrayWrite() 12.22
  • OCILobGetChunkSize() 14.6.2
  • OCILobLocator, out-bind variables 10.4.7
  • OCILobLocator in assignment "=" operations 10.4.6
  • ODP.NET 10.2
  • offset parameter, in DBMS_LOB operations 10.3.2
  • OLEDB 10.9
  • Online Filesystem Reorganization 25.5
  • online redefinition
  • open
    • checking for open BFILEs with FILEISOPEN() 11.11
    • checking if BFILE is open with ISOPEN 11.10
  • open, determining whether a LOB is open 12.8
  • OpenCloseLob.java example 10.8.21.4
  • opening
    • BFILEs using FILEOPEN 11.9
    • BFILEs with OPEN 11.8
  • opening and closing LOBs 2.3
  • ORA-17098
  • ORA-22992 2.7.1
  • oracle.sql.BFILE
  • oracle.sql.BLOB
  • oracle.sql.BLOBs
  • oracle.sql.CLOB
  • oracle.sql.CLOBs
  • Oracle Call Interface, See OCI 10.4
  • Oracle Database Installation 25.1
  • OraclePreparedStatement, See JDBC 10.8.6
  • OracleResultSet, See JDBC 10.8.6
  • OraOLEDB 10.9
  • out-of-line storage 13.3.1

P

  • parallel DML support 9.3.12
  • parallel LONG-to-LOB migration 17.4.4
  • Parallel Online Redefinition 3.5.4
  • partitioned DBFS file system
    • versus non-partitioned 25.2.2
  • partitioned file system
  • partitioned index-organized tables
    • restrictions for LOB columns 13.7
  • pattern
    • check if it exists in BFILE using instr 11.16
  • pattern, if it exists IN LOB using (instr)
  • PCTVERSION 3.2.1, 13.3.5
  • performance
    • guidelines
      • reading/writing large data chunks, temporary LOBs 15.1.4
  • performance guidelines 15.1.3
    • reading/writing large data chunks 15.1.3
  • persistent LOBs 12.20, 12.21
  • pipes 25.3.3.11
  • PL/SQL 10.1
    • and LOBs, semantics changes 8.1
    • changing locator-data linkage 8.3.1
    • CLOBs passed in like VARCHAR2s 8.3.1
    • CLOB variables in 8.3.1
    • CLOB variables in PL/SQL 8.3.1
    • defining a CLOB Variable on a VARCHAR 8.2
    • freeing temporary LOBs automatically and manually 8.3.1
  • PL/SQL functions, remote 5.3.1, 8.4
  • PL/SQL packages for SecureFiles LOB 3.6
  • PM schema 2.5.1
  • polling 11.13, 12.10, 12.20
  • prefetching data 10.4.1
  • prerequisites
    • DBFS file system client 25.3.1
  • print_media creation 6.1
  • print_media table definition 2.5.1
  • privileges
    • to create DBFS file system 25.2.1
  • Pro*C/C++ precompiler
    • available LOB functions 10.2
    • LOB buffering 10.6.8
    • locators 10.6.7
    • modifying internal LOB values 10.6.3
    • opening and closing internal LOBs and external LOBs (BFILEs) 10.6.9
    • providing an allocated input locator pointer 10.6.1
    • reading or examining internal and external LOB values 10.6.4
    • statements for BFILEs 10.6.6
    • statements for temporary LOBs 10.6.5
  • Pro*COBOL precompiler
    • available LOB functions 10.2
    • LOB buffering 10.7.8
    • locators 10.7.7
    • modifying internal LOB values 10.7.3
    • providing an allocated input locator 10.7.1
    • reading or examining internal and external LOBs 10.7.4
    • statements for BFILEs 10.7.6
    • temporary LOBs 10.7.5
  • programmatic environments
    • available functions 10.2
    • compared 10.2
  • programmatic environments for LOBs 10.1

Q

R

  • read consistency
  • read-consistent locators 14.1.4, 14.1.9, 14.3, 14.3.1, 14.3.6, 14.4.5
  • reading
    • large data chunks 15.1.3
    • large data chunks, temporary LOBs 15.1.4
    • portion of BFILE data using substr 11.14
    • small amounts of data, enable buffering 12.25
  • reading, data from a LOB
  • reading, portion of LOB using substr
  • reference semantics 6.3
    • BFILEs enables multiple BFILE columns for each record 11.4
  • registered store
  • remote built-in functions 5.2.1
  • remote LOBs 2.7.1
  • remote PL/SQL functions 5.3.1, 8.4
  • removing
  • restrictions
    • binds of more than 4000 bytes 9.3.11
    • cannot call OCI or DBMS_LOB functions on a NULL LOB 13.1.1.1
    • clustered tables 17.5.2
    • indexes 17.5.4
    • index-organized tables and LOBs 13.7
    • LOBs 2.7
    • triggers 17.5.3
  • restrictions on mounted file systems 25.3.3.11
  • restrictions on remote LOBs 2.7.1
  • RETENTION 3.2.1, 3.3.3
  • RETENTION ignored in an MSSM tablespace 13.3.6
  • retrieving LOB access statistics 15.3.1
  • RETURNING clause, using with INSERT to initialize a LOB 13.1.1.2
  • round-trips to the server, avoiding 14.1.1, 14.1.9

S

  • Samba 25.3.3.11
  • sample schema for examples 6.1
  • SECUREFILE
    • ALTER TABLE parameters 3.3
    • LOB storage parameter 3.2.1
  • SecureFiles Encryption 3.1.2.3
  • SecureFiles LOB
    • CREATE TABLE parameter 3.2
    • PL/SQL 3.6
  • SecureFiles LOBs
    • initialization parameters 3.4.2
  • SecureFiles LOBs and BasicFiles LOBs 1.10
  • SecureFiles LOB Storage 3.1.2
  • SecureFiles Store
  • security
  • SELECT statement
  • semantics
    • copy-based for internal LOBs 6.3
    • copying and referencing 1.6
    • for internal and external LOBs 1.6
    • reference based for BFILEs 11.4
  • semistructured data 1.2
  • SESSION_MAX_OPEN_FILES parameter 16.3.2
  • session collation settings
  • setting
  • simple structured data, complex structured data 1.2
  • Solaris
  • Solaris 11 SRU7
  • spec.sql script 24.3.4
  • SQL
    • character functions, improved 7.1
    • features where LOBs cannot be used 7.4
  • SQL*Loader 16.1.2
  • SQL DDL
  • SQL DML
  • SQL functions on LOBs
  • SQL semantics and LOBs 7.4
  • SQL semantics supported for use with LOBs 7.2
  • statistics, access 15.3
  • streaming
    • do not enable buffering, when using 12.25
    • write 12.21
  • streaming APIs
  • symbolic links, rules with DIRECTORY objects and BFILEs 16.3
  • system owned object, See DIRECTORY object 11.6.1

T

  • TaBleFileSystem Store Provider ("tbfs") 24.3
  • tablespace storage
  • TBFS.SQL script 24.3.2
  • TBL.SQL script 24.3.3
  • TDE 3.1.2.3
  • temporary BLOB
    • checking if temporary using JDBC 12.28.1
  • temporary LOBs 16.2
    • checking if LOB is temporary 12.28
    • DBMS_LOB available functions/procedures 10.3.7
    • OCI functions 10.4.11, 10.5.11
    • Pro*C/C++ precompiler embedded SQL statements 10.6.5
    • Pro*COBOL precompiler statements 10.7.5
    • returned from SQL functions 7.2.6
  • TO_BLOB(),TO_CHAR(), TO_NCHAR() 8.3
  • TO_CLOB()
    • converting VARCHAR2,NVARCHAR2,NCLOB to CLOB 8.3
  • TO_NCLOB() 8.3
  • transaction boundaries
  • transaction IDs 14.4.2
  • transactions
    • external LOBs do not participate in 1.5
    • IDs of locators 14.4.1
    • internal LOBs participate in database transactions 1.4.1
    • LOB locators cannot span 14.4.5
    • locators with non-serializable 14.4.2
    • locators with serializable 14.4.2
    • migrating from 14.1.6
  • transferring LOB data 16.1.3
  • Transparent Data Encryption (TDE) 3.1.2.3
  • transparent read 22.5.6
  • triggers
    • LONG-to-LOB migration 17.5.3
  • trimming LOB data
  • trimming LOBs using JDBC 10.8.22

U

  • UCS2 Unicode character set
    • varying width character data 13.2.2
  • UNICODE
    • VARCHAR2 and CLOBs support 7.2.4
  • unmounting
  • unstructured data 1.2, 1.2.3
  • updated locators 14.1.4, 14.3.3, 14.3.6
  • UPDATE statements
    • binds of greater than 4000 bytes 9.3.8
  • updating
  • using SQL character functions 7.1

V

  • V$NLS_VALID_VALUES 10.3.3
  • VARCHAR2
    • accessing CLOB data when treated as 8.2
    • also RAW, applied to CLOBs and BLOBs 7.5
    • defining CLOB variable on 8.2
  • VARCHAR2, using SQL functions and operators with LOBs 7.2
  • VARRAY
  • VARRAYs
  • varying-width character data 13.2.2
  • views on DIRECTORY object 11.6.5

W

  • wallet
  • Wallet,Oracle 25.4.1
  • WebDAV
  • WHERE Clause Usage with LOBs 7.5.4
  • writing
    • data to a LOB 12.21
    • large data chunks, temporary LOBs 15.1.4
    • singly or piecewise 12.20
    • small amounts of data, enable buffering 12.25

Z

  • Zero-copy Input/Output for SecureFiles LOBs 10.8.5