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 1
  • accessing external LOBs 1
  • accessing LOBs 1
  • access statistics for LOBs 1
  • administrative APIs 1
  • Advanced LOB compression 1
  • Advanced LOB Deduplication 1
  • ALTER TABLE parameters for SecureFiles LOBs 1
  • amount 1
  • amount parameter
    • used with BFILEs 1
  • appending
    • writing to the end of a LOB 1
  • array read 1
  • array write 1
  • assigning OCILobLocator pointers 1
  • ASSM tablespace 1 , 2 , 3 , 4 , 5
  • available LOB methods 1

B

  • BASICFILE
    • LOB storage parameter 1
  • BasicFiles LOBs and SecureFiles LOBs 1
  • BasicFiles LOB Storage 1
  • BFILE-buffering, See JDBC 1
  • BFILE class, See JDBC 1
  • BFILENAME function 1 , 2
  • BFILEs
    • accessing 1
    • converting to CLOB or NCLOB 1
    • creating an object in object cache 1
    • DBMS_LOB, offset and amount parameters in bytes 1
    • DBMS_LOB read-only procedures 1
    • locators 1
    • maximum number of open 1 , 2
    • maximum size 1
    • multithreaded server mode 1 , 2
    • not affected by LOB storage properties 1
    • OCI functions to read/examine values 1 , 2
    • OCI read-only functions 1 , 2
    • opening and closing using JDBC 1
    • Pro*C/C++ precompiler statements 1
    • Pro*COBOL precompiler embedded SQL statements 1
    • reading with DBMS_LOB 1
    • security 1
    • storage devices 1
    • streaming APIs 1
    • using JDBC to read/examine 1
    • using Pro*C/C++ precompiler to open and close 1
  • binds
    • See also INSERT statements and UPDATE statements 1
  • bind variables, used with LOB locators in OCI 1
  • BLOB-buffering, See JDBC 1
  • BLOBs
    • class 1 , 2
    • DBMS_LOB, offset and amount parameters in bytes 1
    • maximum size 1
    • modify using DBMS_LOB 1
    • using JDBC to modify 1
    • using JDBC to read/examine BLOB values 1
    • using oracle.sql.BLOB methods to modify 1
  • body.sql script 1
  • buffering
    • disable persistent LOBs 1
    • LOB buffering subsystem 1
  • buffering, enable
    • persistent LOBs 1
  • buffering, flush
    • persistent LOBs 1
  • built-in functions, remote 1

C

  • C, See OCI 1
  • C++, See Pro*C/C++ precompiler 1
  • CACHE / NOCACHE 1
  • caches
    • object cache 1
  • callback 1 , 2 , 3
  • capi.sql script 1
  • catalog views
    • v$temporary_lobs 1
  • character data
    • varying width 1
  • character set ID
    • See CSID parameter 1
  • character set ID, getting
    • persistent LOBs 1
  • charactersets
    • multibyte, LONG and LOB datatypes 1
  • CHECKACCESS 1
  • CHUNK 1 , 2
  • chunk size
    • and LOB storage properties 1
    • multiple of, to improve performance 1
  • CLOB
    • session collation settings 1
  • CLOB-buffering, See JDBC 1
  • CLOBs
    • class, See JDBC 1
    • columns
      • varying- width character data 1
    • datatype
      • varying-width columns 1
    • DBMS_LOB, offset and amount parameters in characters 1
    • modify using DBMS_LOB 1
    • opening and closing using JDBC 1
    • reading/examining with JDBC 1
    • using JDBC to modify 1
  • closing
    • all open BFILEs 1
    • BFILEs with CLOSE 1
    • BFILEs with FILECLOSE 1
  • clustered tables 1
  • COBOL, See Pro*COBOL precompiler 1
  • codepoint semantics 1
  • comparing
    • all or parts of two BFILEs 1
  • comparing, all or part of two LOBs
    • persistent LOBs 1
  • COMPRESS 1 , 2
  • compression
    • Advanced LOB 1
  • content store
    • listing 1
    • looking up 1
    • registering 1
    • unmounting 1
  • conventional path load 1
  • conversion
    • explicit functions for PL/SQL 1
  • conversion, implicit from CLOB to character type 1
  • conversions
    • character set 1
    • from binary data to character set 1
    • implicit, between CLOB and VARCHAR2 1
  • converting
    • to CLOB 1
  • copying
    • directories 1
    • files 1
    • LOB locator
      • persistent LOBs 1
    • LOB locator for BFILE 1
  • copying, all or part of a LOB to another LOB
    • persistent LOBs 1
  • copy semantics
    • internal LOBs 1
  • CREATE TABLE and SecureFiles LOB features 1
  • CREATE TABLE parameters for SecureFiles LOBs 1
  • CREATE TABLE syntax and notes 1
  • creating
    • a directory 1
    • partitioned file system 1
  • creating a non-partitioned file system 1
  • creating SecureFiles File System Store 1
  • CSID parameter
    • setting OCILobRead and OCILobWrite to OCI_UCS2ID 1

D

  • database file system links 1
  • data interface for persistent LOBs
    • multibyte charactersets 1
  • data interface for remote LOBs 1
  • data interface in Java 1
  • Data Pump
    • SecureFiles LOBs 1
  • Data Pumping
    • transferring LOB data 1
  • db_securefile init.ora parameter 1
  • DBFS
    • administration 1
    • backing up 1
    • body.sql script 1
    • caching 1
    • capi.sql script 1
    • client 1
    • command-Line interface 1
    • Content SPI (Store Provider Interface) 1
    • content store 1
    • creating a custom provider 1
    • creating a custom provider, mechanics 1
    • creating SecureFiles File System Store 1
    • custom provider sample installation and setup 1
    • DBFS Server 1
    • diagnostics 1
    • example store provider 1
    • FTP access 1
    • hierachical store, setting up 1
    • hierarchical store, dropping 1
    • hierarchical store, setting up 1
    • hierarchical store, using 1
    • hierarchical store, using compression 1
    • hierarchical store, using tape 1
    • Hierarchical Store Package, DBMS_DBFS_HS 1
    • HS store wallet, setting up 1
    • HTTP access to 1
    • internet access 1
    • managing client failover 1
    • Online Filesystem Reorganization 1
    • overview 1
    • RAC cluster 1
    • reorganizing file systemsDBFS
      • online redefinition 1
    • SecureFiles LOB advanced features 1
    • SecureFiles Store
      • setting up 1
    • SecureFiles Store File Systems, dropping 1
    • SecureFiles Store File Systems, initializing 1
    • sharing 1
    • shrinking file systems 1
    • small file performance 1
    • spec.sql script 1
    • store creation 1
    • TaBleFileSystem Store Provider ("tbfs") 1
    • TBFS.SQL script 1
    • TBL.SQL script 1
    • using a SecureFiles Store File System 1
    • using Oracle Wallet 1
    • XDB internet access 1
  • DBFS Content API
    • abstract operations 1
    • access checks 1
    • and stores 1
    • content IDs 1
    • creation operations 1
    • deletion operations 1
    • directory listings 1
    • exceptions 1
    • get operations 1
    • getting started 1
    • interface versioning 1
    • locking operations 1
    • lock types 1
    • move operations 1
    • navigation 1
    • optional properties 1
    • overview 1
    • path names 1
    • path name types 1
    • path normalization 1
    • path properties 1
    • property access flags 1
    • property bundles 1
    • put operations 1
    • rename operations 1
    • role 1
    • search 1
    • session defaults 1
    • space usage 1
    • standard properties 1
    • statistics support 1
    • store descriptors 1
    • store features 1
    • structure, properties 1
    • tracing support 1
    • types and constants 1
    • user-defined properties 1
    • using 1
  • DBFS content store path
    • creating 1
  • DBFS file system
    • accessing 1
    • client prerequisites 1
    • creating
      • creating a DBFS file system 1
    • dropping 1
    • partitioned versus non-partitioned 1
  • DBFS installation 1
  • DBFS links 1
  • DBFS mounting interface
    • Linux and Solaris 1
  • DBFS Mounting Interface (Linux Only) 1
  • DBFS SecureFiles Store
    • setting up permissions 1
  • DBFS SecureFiles Store Package, DBMS_DBFS_SFS 1
  • DBFS SPI (DBMS_DBFS_CONTENT_SPI) 1
  • DBFS Store
    • mounting 1
  • DBMS_DBFS_CONTENT_SPI 1
  • DBMS_DBFS_HS 1
  • DBMS_DBFS_HS package
    • methods 1
    • views 1
  • DBMS_LOB
    • updating LOB with bind variable 1
  • DBMS_LOB.GET_STORAGE_LIMIT 1
  • DBMS_LOB.GETCHUNKSIZE 1
  • DBMS_LOB.GETLENGTH return value 1
  • DBMS_LOB.LOADCLOBFROMFILE 1
  • DBMS_LOB.WRITE()
    • passing hexadecimal string to 1
  • DBMS_LOB functions on a NULL LOB restriction 1
  • DBMS_LOB package
    • available LOB procedures/functions 1
    • for temporary LOBs 1
    • functions/procedures to modify BLOB, CLOB, and NCLOB 1
    • functions/procedures to read/examine internal and external LOBs 1
    • multithreaded server 1
    • multithreaded server mode 1
    • offset and amount parameter guidelines 1
    • open and close, JDBC replacements for 1
    • opening/closing internal and external LOBs 1
    • provide LOB locator before invoking 1
    • read-only functions/procedures for BFILEs 1
    • to work with LOBs, using 1
    • using with SecureFiles and DBFS 1
    • WRITE()
      • guidelines 1
  • DBMS_REDEFINITION package 1
  • DBMS_SPACE package 1
  • DECRYPT 1 , 2
  • DEDUPLICATE 1 , 2
  • deduplication
    • Advanced LOB 1
  • diagnostics
    • DBFS 1
  • directories
    • catalog views 1
    • creating 1
    • guidelines for usage 1
    • listing 1
    • ownership and privileges 1
  • DIRECTORY object
    • catalog views 1
    • getting the alias and filename 1
    • guidelines for usage 1
    • names on Windows platforms 1
    • name specification 1
    • READ permission on object not individual files 1
    • rules for using 1
    • symbolic links, and 1
  • direct-path load 1
  • DISABLE STORAGE IN ROW 1
  • displaying
    • LOB data for persistent LOBs 1
  • domain indexing on LOB columns 1

E

  • embedded SQL statements, See Pro*C/C++ precompiler and Pro*COBOL precompiler 1
  • EMPTY_BLOB() and EMPTY_CLOB, LOB storage properties for 1
  • EMPTY_CLOB()/BLOB()
    • to initialize internal LOB 1
  • empty LOBs
    • creating using JDBC 1
    • JDBC 1
  • ENABLE STORAGE IN ROW 1
  • ENCRYPT 1 , 2
  • encryption
    • SecureFiles 1
  • equal, one LOB locator to another
    • persistent LOBs 1
  • erasing, part of LOB
    • persistent LOBs 1
  • examples
    • repercussions of mixing SQL DML with DBMS_LOB 1
    • updated LOB locators 1
    • updating a LOB with a PL/SQL variable 1
  • examples, LOB access statistics 1
  • existence
    • check for BFILE 1
  • extensible indexes 1
  • external callout 1
  • external LOBs (BFILEs)
    • See BFILEs 1
  • external LOBs (BFILEs), See BFILEs 1

F

  • file system
    • links 1
    • security model 1
  • FILESYSTEM_LIKE_LOGGING
    • LOB storage parameter 1
  • flushing
    • buffer 1
    • LOB buffer 1
  • FOR UPDATE clause
    • LOB locator 1
  • FREELIST GROUPS 1
  • FREELISTS 1
  • FREEPOOLS 1
  • FTP
    • access to DBFS 1
  • function-based indexes
    • on LOB columns 1
  • FUSE
    • installing 1

G

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

H

  • hexadecimal string
    • passing to DBMS_LOB.WRITE() 1
  • hierarchical store
    • dropping 1
    • setting up 1
    • using 1
    • using compression 1
    • using tape 1
  • Hierarchical Store Package, DBMS_DBFS_HS 1
  • HS store wallet 1
  • HTTP
    • access to DBFS 1
  • HTTP access to DBFS 1

I

  • implicit assignment and parameter passing for LOB columns 1
  • implicit conversion of CLOB to character type 1
  • improved LOB usability 1
  • indexes
    • function-based 1
    • rebuilding after LONG-to-LOB migration 1
    • restrictions 1
  • indexes on LOB columns
    • bitmap index not supported 1
    • B-tree index not supported 1
    • domain indexing 1
    • restriction 1
  • index-organized tables, restrictions for LOB columns 1
  • Information Lifecycle Management (ILM) 1
  • init.ora parameter db_securefile 1
  • INITFS 1
  • initialization parameters for SecureFiles LOBs 1
  • initializing
    • during CREATE TABLE or INSERT 1
    • using EMPTY_CLOB(), EMPTY_BLOB() 1
  • initializing a LOB column to a non-NULLvalue 1
  • inline storage
    • maximum size 1
  • inserting
    • a row by initializing a LOB locator
      • internal persistent LOBs 1
    • a row by initializing BFILE locator 1
  • INSERT statements
    • binds of greater than 4000 bytes 1
  • installing
    • DBFS 1
    • FUSE 1
    • Oracle Database 1
  • interfaces for LOBs, see programmatic environments 1
  • ioctl 1
  • IS NULL return value for LOBs 1
  • ISNULL usage with LOBs 1
  • IS NULL usage with LOBs 1

J

  • Java, See JDBC 1
  • JDBC
    • available LOB methods/properties 1
    • BFILE-buffering 1
    • BFILE class 1
    • BFILE streaming APIs 1
    • BLOB and CLOB classes 1
    • calling DBMS_LOB package 1
    • checking if BLOB is temporary 1
    • CLOB streaming APIs 1
    • empty LOBs 1
    • encapsulating locators 1
    • methods/properties for BLOB-buffering 1
    • methods/properties for CLOBs
      • buffering 1
    • modifying BLOB values 1
    • modifying CLOB values 1
    • modifyng internal LOBs with Java using oracle.sql.BLOB/CLOB 1
    • newStreamLob.java 1
    • opening and closing BFILEs 1
    • opening and closing CLOBs 1
    • opening and closing LOBs 1
    • reading/examining BLOB values 1
    • reading/examining CLOB values 1
    • reading/examining external LOB (BFILE) values 1
    • reading internal LOBs and external LOBs (BFILEs) with Java 1
    • referencing LOBs 1
    • streaming APIs for LOBs 1
    • syntax references 1
    • trimming LOBs 1
    • using OracleResultSet to reference LOBs 1
    • using OUT parameter from OraclePreparedStatement to reference LOBs 1
    • writing to empty LOBs 1
  • JDBC 3.0 1
  • JDBC and Empty LOBs 1

K

  • KEEP_DUPLICATES 1 , 2

L

  • LBS, See Lob Buffering Subsystem (LBS) 1
  • length
    • getting BFILE 1
    • persistent LOB 1
  • LENGTH return value for LOBs 1
  • libaio
    • asynchronous I/O through 1
  • Linux
    • DBFS mounting interface 1
  • listing
    • a directory 1
  • loading
    • a LOB with BFILE data 1
    • LOB with data from a BFILE 1
  • loading BEFILEs
    • using SQL*Loader 1
  • loading data into LOBs
    • utilities 1
  • LOB buffering
    • BLOB-buffering with JDBC 1
    • buffer-enabled locators 1
    • example 1
    • flushing the buffer 1
    • flushing the updated LOB through LBS 1
    • guidelines 1
    • OCI example 1
    • OCI functions 1
    • physical structure of buffer 1
    • Pro*C/C++ precompiler statements 1
    • Pro*COBOL precompiler statements 1
    • usage notes 1
  • LOB Buffering Subsystem (LBS)
    • advantages 1
    • buffer-enabled locators 1
    • buffering example using OCI 1
    • example 1
    • flushing
      • updated LOB 1
    • flushing the buffer 1
    • guidelines 1
    • saving the state of locator to avoid reselect 1
    • usage 1
  • LOB Buffering SubSystem (LBS) 1
  • LOB column cells
    • accessing 1
  • LOB columns
    • initializing to contain locator 1
    • initializing to NULL or Empty 1
  • LOB column states 1
  • LOB locator
    • copy semantics 1
    • external LOBs (BFILEs) 1
    • internal LOBs 1
    • out-bind variables in OCI 1
    • reference semantics 1
  • LOB locators 1
  • LOB locators, always stored in row 1
  • LOB prefetching
    • JDBC 1
  • LOB reads 1
  • LOB restrictions 1
  • LOBs
    • accesing with SQL 1
    • accessing 1
    • accessing using the data interface 1
    • accessing using the locator interface 1
    • attributes and object cache 1
    • buffering
      • caveats 1
      • pages can be aged out 1
    • buffering subsystem 1
    • buffering usage notes 1
    • changing default tablespace storage 1
    • data types versus LONG 1
    • external (BFILEs) 1
    • flushing 1
    • interfaces, See programmatic environments 1
    • interMEDIA 1
    • internal
      • creating an object in object cache 1
    • internal LOBs
      • CACHE / NOCACHE 1
      • CHUNK 1
      • ENABLE | DISABLE STORAGE IN ROW 1
      • initializing 1
      • introduced 1
      • locators 1
      • locking before updating 1 , 2 , 3 , 4 , 5 , 6
      • LOGGING / NOLOGGING 1
      • PCTVERSION 1
      • setting to empty 1
      • tablespace and LOB index 1
      • tablespace and storage characteristics 1
      • transactions 1
    • in the object cache 1
    • loading data into, using SQL*Loader 1
    • locator 1
    • locators 1 , 2
    • locking rows 1
    • maximum sizes allowed 1
    • object cache 1
    • piecewise operations 1
    • read-consistent locators 1
    • reason for using 1
    • setting to contain a locator 1
    • setting to NULL 1
    • tables
      • creating indexes 1
      • moving partitions 1
      • splitting partitions 1
    • unstructured data 1
    • updated LOB locators 1
    • value 1
    • varying-width character data 1
  • LOBS
    • opening and closing 1
  • LOBs, data interface for remote 1
  • LOBs, data interface in Java 1
  • LOB storage
    • format of varying width character data 1
    • inline and out-of-line storage properties 1
  • LOB writes 1
  • LOB writes unaligned 1
  • locators
    • BFILE guidelines 1
    • BFILEs 1
    • BFILEs, two rows can refer to the same file 1
    • buffer-enabled 1
    • external LOBs (BFILEs) 1
    • LOB 1
    • LOB, cannot span transactions 1
    • multiple 1
    • OCI functions 1 , 2
    • Pro*COBOL precompiler statements 1
    • providing in Pro*COBOL precompiler 1
    • read-consistent 1 , 2 , 3 , 5 , 6
    • read consistent, updating 1
    • reading and writing to a LOB using 1
    • saving the state to avoid reselect 1
    • selecting within a transaction 1
    • selecting without current transaction 1
    • setting column to contain 1
    • transaction boundaries 1
    • updated 1 , 2 , 3
    • updating 1
  • locators, see if LOB locator is initialized
    • persistent LOBs 1
  • locking 1
  • locking a row containing a LOB 1
  • LOGGING
    • LOB storage parameter 1
    • migrating LONG-to-LOBs 1
  • LOGGING / NOLOGGING 1
  • LONG-to-LOB migration
    • ALTER TABLE 1
    • benefits and concepts 1
    • clustered tables 1
    • LOGGING 1
    • NULLs 1
    • rebuilding indexes 1
    • replication 1
    • triggers 1
  • LONG versus LOB data types 1

M

  • MAXSIZE 1
  • migrating
    • LONG-to-LOBs, constraints maintained 1
    • LONG-to-LOBs, indexing 1
    • LONG to LOBs, see LONG-to-LOB 1
    • LONG-to-LOB using ALTER TABLE 1
  • migrating to SecureFiles LOBs 1 , 2
  • migration of LONG to LOB in parallel 1
  • mounted file systems
    • restrictions 1
  • mounting
    • DBFS through fstab for Linux 1
    • DBFS through fstab for Solaris 1
    • the DBFS store 1
  • mount points
    • listing 1
  • multibyte character sets, using with the data interface for LOBs 1
  • multithreaded server
    • BFILEs 1 , 2

N

  • NCLOB
    • session collation settings 1
  • NCLOBs
    • DBMS_LOB, offset and amount parameters in characters 1
    • modify using DBMS_LOB 1
  • NewStreamLob.java 1
  • NOCOMPRESS 1 , 2
  • NOCOPY, using to pass temporary LOB parameters by reference 1
  • NOLOGGING
    • LOB storage parameter 1
  • non-partitioned file system
    • creating 1
  • NORMALIZEPATH 1
  • NULL LOB, restrictions calling OCI and DBMS_LOB functions 1
  • NULL LOB value, LOB storage for 1
  • NULL LOB values, LOB storage properties for 1

O

  • object cache
    • creating an object in 1
    • LOBs 1
  • OCCI
    • compared to other interfaces 1
    • LOB functionality 1
  • OCCI Blob class
    • read 1
    • write 1
  • OCCI Clob class
    • read 1
    • write 1
  • OCI
    • available LOB functions 1
    • character set rules, fixed-width and varying-width 1
    • functions for BFILEs 1 , 2
    • functions for temporary LOBs 1 , 2
    • functions to modify internal LOB values 1 , 2
    • functions to open/close internal and external LOBs 1 , 2
    • functions to read or examine internal and external LOB values 1 , 2
    • LOB buffering example 1
    • Lob-buffering functions 1
    • LOB locator functions 1 , 2
    • NCLOB parameters 1 , 2
    • OCILobFileGetLength
      • CLOB and NCLOB input and output length 1
    • OCILobRead2()
      • varying-width CLOB and NCLOB input and amount amounts 1
    • OCILobWrite2()
      • varying-width CLOB and NCLOB input and amount amounts 1 , 2
    • offset and amount parameter rules
      • fixed-width character sets 1
    • setting OCILobRead2(), OCILobWrite2() to OCI_UCS2ID 1
    • using to work LOBs 1
  • OCI functions on a NULL LOB restriction 1
  • OCILobArrayRead() 1
  • OCILobArrayWrite() 1
  • OCILobGetChunkSize() 1
  • OCILobLocator, out-bind variables 1
  • OCILobLocator in assignment "=" operations 1
  • ODP.NET 1
  • offset parameter, in DBMS_LOB operations 1
  • OLEDB 1
  • Online Filesystem Reorganization 1
  • online redefinition
    • DBFS 1
  • open
    • checking for open BFILEs with FILEISOPEN() 1
    • checking if BFILE is open with ISOPEN 1
  • open, determining whether a LOB is open 1
  • OpenCloseLob.java example 1
  • opening
    • BFILEs using FILEOPEN 1
    • BFILEs with OPEN 1
  • opening and closing LOBs
    • using JDBC 1
  • ORA-17098
    • empty LOBs and JDBC 1
  • ORA-22992 1
  • oracle.sql.BFILE
    • BFILE-buffering 1
    • JDBC methods to read/examine BFILEs 1
  • oracle.sql.BLOB
    • for modifying BLOB values 1
    • reading/examining BLOB values 1
    • See JDBC 1
  • oracle.sql.BLOBs
    • BLOB-buffering 1
  • oracle.sql.CLOB
    • CLOBs
      • buffering 1
    • JDBC methods to read/examine CLOB values 1
    • modifying CLOB values 1
  • oracle.sql.CLOBs
    • See JDBC 1
  • Oracle Call Interface, See OCI 1
  • Oracle Database Installation 1
  • OraclePreparedStatement, See JDBC 1
  • OracleResultSet, See JDBC 1
  • OraOLEDB 1
  • out-of-line storage 1

P

  • parallel DML support 1
  • parallel LONG-to-LOB migration 1
  • Parallel Online Redefinition 1
  • partitioned DBFS file system
    • versus non-partitioned 1
  • partitioned file system
    • creating 1
  • partitioned index-organized tables
    • restrictions for LOB columns 1
  • pattern
    • check if it exists in BFILE using instr 1
  • pattern, if it exists IN LOB using (instr)
    • persistent LOBs 1
  • PCTVERSION 1 , 2
  • performance
    • guidelines
      • reading/writing large data chunks, temporary LOBs 1
  • performance guidelines
    • reading/writing large data chunks 1
  • persistent LOBs 1 , 2
  • pipes 1
  • PL/SQL
    • and LOBs, semantics changes 1
    • changing locator-data linkage 1
    • CLOBs passed in like VARCHAR2s 1
    • CLOB variables in 1
    • CLOB variables in PL/SQL 1
    • defining a CLOB Variable on a VARCHAR 1
    • freeing temporary LOBs automatically and manually 1
  • PL/SQL functions, remote 1
  • PL/SQL packages for SecureFiles LOB 1
  • PM schema 1
  • polling 1 , 2 , 3
  • prefetching data 1
  • prerequisites
    • DBFS file system client 1
  • print_media creation 1
  • print_media table definition 1
  • privileges
    • to create DBFS file system 1
  • Pro*C/C++ precompiler
    • available LOB functions 1
    • LOB buffering 1
    • locators 1
    • modifying internal LOB values 1
    • opening and closing internal LOBs and external LOBs (BFILEs) 1
    • providing an allocated input locator pointer 1
    • reading or examining internal and external LOB values 1
    • statements for BFILEs 1
    • statements for temporary LOBs 1
  • Pro*COBOL precompiler
    • available LOB functions 1
    • LOB buffering 1
    • locators 1
    • modifying internal LOB values 1
    • providing an allocated input locator 1
    • reading or examining internal and external LOBs 1
    • statements for BFILEs 1
    • temporary LOBs 1
  • programmatic environments
    • available functions 1
    • compared 1
  • programmatic environments for LOBs 1

Q

  • Query APIs 1

R

  • read consistency
    • LOBs 1
  • read-consistent locators 1 , 2 , 3 , 4 , 5 , 6
  • reading
    • large data chunks 1
    • large data chunks, temporary LOBs 1
    • portion of BFILE data using substr 1
    • small amounts of data, enable buffering 1
  • reading, data from a LOB
    • persistent LOBs 1
  • reading, portion of LOB using substr
    • persistent LOBs 1
  • reference semantics
    • BFILEs enables multiple BFILE columns for each record 1
  • registered store
    • mounting 1
    • unregistering 1
  • remote built-in functions 1
  • remote LOBs 1
  • remote PL/SQL functions 1
  • removing
    • directories 1
    • files 1
  • replication 1
  • restrictions
    • binds of more than 4000 bytes 1
    • cannot call OCI or DBMS_LOB functions on a NULL LOB 1
    • clustered tables 1
    • indexes 1
    • index-organized tables and LOBs 1
    • LOBs 1
    • replication 1
    • triggers 1
  • restrictions on mounted file systems 1
  • restrictions on remote LOBs 1
  • RETENTION 1 , 2
  • RETENTION ignored in an MSSM tablespace 1
  • retrieving LOB access statistics 1
  • RETURNING clause, using with INSERT to initialize a LOB 1
  • round-trips to the server, avoiding 1 , 2

S

  • Samba 1
  • sample schema for examples 1
  • SECUREFILE
    • ALTER TABLE parameters 1
    • LOB storage parameter 1
  • SecureFiles Encryption 1
  • SecureFiles LOB
    • CREATE TABLE parameter 1
    • PL/SQL 1
  • SecureFiles LOBs
    • initialization parameters 1
  • SecureFiles LOBs and BasicFiles LOBs 1
  • SecureFiles LOB Storage 1
  • SecureFiles Store
    • setting up 1
  • security
    • BFILEs 1
    • BFILEs using SQL DDL 1
    • BFILEs using SQL DML 1
  • SELECT statement
    • read consistency 1
  • semantics
    • copy-based for internal LOBs 1
    • copying and referencing 1
    • for internal and external LOBs 1
    • reference based for BFILEs 1
  • semistructured data 1
  • SESSION_MAX_OPEN_FILES parameter 1
  • session collation settings
    • CLOB and NCLOB 1
  • setting
    • internal LOBs to empty 1
    • LOBs to NULL 1
    • overrides for NLS_LANG variable 1
  • simple structured data, complex structured data 1
  • Solaris
    • mounting interface 1
    • Solaris-Specific privileges 1
  • Solaris 11 SRU7
    • installing FUSE 1
  • spec.sql script 1
  • SQL
    • character functions, improved 1
    • features where LOBs cannot be used 1
  • SQL*Loader
    • conventional path load 1
    • direct-path load 1
    • LOBs
      • loading data into 1
  • SQL DDL
    • BFILE security 1
  • SQL DML
    • BFILE security 1
  • SQL functions on LOBs
    • return type 1
    • return value 1
    • temporary LOBs returned 1
  • SQL semantics and LOBs 1
  • SQL semantics supported for use with LOBs 1
  • statistics, access 1
  • streaming
    • do not enable buffering, when using 1
    • write 1
  • streaming APIs
    • NewStreamLob.java 1
    • using JDBC and BFILEs 1
    • using JDBC and CLOBs 1
    • using JDBC and LOBs 1
  • symbolic links, rules with DIRECTORY objects and BFILEs 1
  • system owned object, See DIRECTORY object 1

T

  • TaBleFileSystem Store Provider ("tbfs") 1
  • tablespace storage
    • changing 1
  • TBFS.SQL script 1
  • TBL.SQL script 1
  • TDE 1
  • temporary BLOB
    • checking if temporary using JDBC 1
  • temporary LOBs
    • checking if LOB is temporary 1
    • DBMS_LOB available functions/procedures 1
    • OCI functions 1 , 2
    • Pro*C/C++ precompiler embedded SQL statements 1
    • Pro*COBOL precompiler statements 1
    • returned from SQL functions 1
  • TO_BLOB(),TO_CHAR(), TO_NCHAR() 1
  • TO_CLOB()
    • converting VARCHAR2,NVARCHAR2,NCLOB to CLOB 1
  • TO_NCLOB() 1
  • transaction boundaries
    • LOB locators 1
  • transaction IDs 1
  • transactions
    • external LOBs do not participate in 1
    • IDs of locators 1
    • internal LOBs participate in database transactions 1
    • LOB locators cannot span 1
    • locators with non-serializable 1
    • locators with serializable 1
    • migrating from 1
  • transferring LOB data 1
  • Transparent Data Encryption (TDE) 1
  • transparent read 1
  • triggers
    • LONG-to-LOB migration 1
  • trimming LOB data
    • persistent LOBs 1
  • trimming LOBs using JDBC 1

U

  • UCS2 Unicode character set
    • varying width character data 1
  • UNICODE
    • VARCHAR2 and CLOBs support 1
  • unmounting
    • a file system 1
  • unstructured data 1 , 2
  • updated locators 1 , 2 , 3
  • UPDATE statements
    • binds of greater than 4000 bytes 1
  • updating
    • avoid the LOB with different locators 1
    • LOBs using SQL and DBMS_LOB 1
    • LOB values, read consistent locators 1
    • LOB values using one locator 1
    • LOB with PL/SQL bind variable 1
    • locators 1
    • locking before 1
    • locking prior to 1 , 2 , 3
  • using SQL character functions 1

V

  • V$NLS_VALID_VALUES 1
  • VARCHAR2
    • accessing CLOB data when treated as 1
    • also RAW, applied to CLOBs and BLOBs 1
    • defining CLOB variable on 1
  • VARCHAR2, using SQL functions and operators with LOBs 1
  • VARRAY
    • LOB restriction 1
  • VARRAYs
    • stored as LOBs 1
  • varying-width character data 1
  • views on DIRECTORY object 1

W

  • wallet
    • HS store wallet 1
  • Wallet,Oracle 1
  • WebDAV
    • access to DBFS 1
  • WHERE Clause Usage with LOBs 1
  • writing
    • data to a LOB 1
    • large data chunks, temporary LOBs 1
    • singly or piecewise 1
    • small amounts of data, enable buffering 1

Z

  • Zero-copy Input/Output for SecureFiles LOBs 1