How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
1.6.1 Oracle SecureFiles → Oracle SecureFiles. Enhancements include built-in compression and encryption.
Contents → Part II Application Design 4 Using Oracle SecureFiles Storage of SecureFiles Parameters for CREATE … TABLE Examples for Encryption PL/SQL Packages for SecureFiles: Column Settings DBMS_LOB Package … Initialization Parameter for SecureFiles db_securefile Compatibility and Upgrading Migrating Columns … from BasicFile
Using SecureFiles → Starting with Oracle Database 11 g Release 1, SecureFiles add powerful new features for LOB … compression, encryption, and deduplication. See Also: Oracle Database SecureFiles and Large Objects Developer's Guide
Intelligent LOB Compression, Deduplication, and Encryption with SecureFiles → SecureFiles. SecureFiles, in addition to performance, supports efficient compression, deduplication … Database, and is available for random reads and writes. For more information about SecureFiles, see Oracle … Database SecureFiles and Large Objects Developer's Guide. See also Oracle Database SQL Language
Predefined PL/SQL Large Object (LOB) Data Types → Oracle Database SecureFiles and Large Objects Developer's Guide for more information about LOBs Topics
Oracle SecureFiles → Java/JDBC applications get richer SecureFiles LOB data manipulation API and performance … , compression, encryption, sharing, and client-side read. This feature is covered in \"Oracle SecureFiles\".
Related Documents → Developer's Guide Oracle Database SecureFiles and Large Objects Developer's Guide Oracle Database Object
4 Using Oracle SecureFiles → This chapter describes how to use SecureFiles, which were introduced to supplement the original … topics: Storage of SecureFiles PL/SQL Packages for SecureFiles: Column Settings Initialization Parameter … for SecureFiles Compatibility and Upgrading Migrating Columns from BasicFile LOBs to SecureFiles
Storage of SecureFiles → This section summarizes LOB storage characteristics used to design tables with LOB column types. Beginning with Release 11.1, a new LOB storage paradigm is used by the database when the storage keyword SECUREFILE appears in the CREATE TABLE statement. The old storage paradigm is in effect if the keyword SECUREFILE is not used, or if the keyword BASICFILE is used. BASICFILE (the original LOB storage
Initialization Parameter for SecureFiles → The db_securefile parameter is set in the file init.ora:
42.21 Oracle SecureFiles Known Bugs → Bug 6316423 Executing CREATE TABLE AS SELECT... ENCRYPT fails with internal errors. Workaround: Execute ALTER TABLE MODIFY... ENCRYPT after CREATE TABLE AS SELECT without the ENCRYPT option. This bug is fixed in Oracle Database 11 g Patch Set 1 (22.214.171.124.0). Bug 6191877 Executing ALTER TABLE MOVE with SecureFile LOBs encrypted fails with internal errors. Workaround: Drop the table after exporting
CREATE TABLE Examples for Compression → Create a table with a SECUREFILE compressed LOB column. The compression level is MEDIUM by default. CREATE TABLE t1 ( a CLOB) LOB(a) STORE AS SECUREFILE ( COMPRESS CACHE NOLOGGING ); Create a table with a SECUREFILE LOB column having the high level of compression. CREATE TABLE t1 ( a CLOB) LOB(a) STORE AS SECUREFILE ( COMPRESS HIGH CACHE ); Create a table with a SECUREFILE LOB column and LOB compression
ALTER TABLE Usage Notes for Compression → HIGH setting incurs more work, but will compress the data better. The default is MEDIUM. LOB compression is applicable only to SecureFiles.
CREATE TABLE Examples for Encryption → Create a table with SECUREFILE LOB column and LOB encryption enabled using AES128. CREATE TABLE t1 ( a CLOB ENCRYPT USING 'AES128') LOB(a) STORE AS SECUREFILE ( CACHE ); Create a table with SECUREFILE LOB column and with LOB encryption enabled on all partitions. CREATE TABLE t1 ( REGION VARCHAR2(20), a BLOB) LOB(a) STORE AS SECUREFILE ( ENCRYPT USING 'AES128' NOCACHE FILESYSTEM_LIKE_LOGGING ) PARTITION
Preventing Generation of Redo Space when Migrating to SecureFile LOBs → Generation of redo space can cause performance problems during the process of migrating BasicFile LOB columns. Redo changes for the table are logged during the migration process only if the table has LOGGING set. Redo changes for the column being converted from BasicFile LOB to SecureFile are logged only if the storage characteristics of the SecureFile LOB column indicate LOGGING. The logging setting
CREATE TABLE Usage Notes for Compression → SecureFile compression does not entail table or index compression and vice-versa. A server-wide default SecureFile compression algorithm is used. MEDIUM and HIGH options provide varying degrees of compression. The higher the degree of compression, the higher the latency incurred. The HIGH setting incurs more work, but will compress the data better. The default is MEDIUM. Compression can be specified
Parameters for ALTER TABLE With SECUREFILE LOBs → from BasicFile LOBs to SecureFiles\" Oracle Database SQL Language Reference ALTER TABLE statement
ALTER TABLE Examples for Compression → Disable compression on a SECUREFILE LOB. ALTER TABLE t1 MODIFY LOB(a) ( NOCOMPRESS ); Enable compression on a SECUREFILE LOB with a high degree of compression. ALTER TABLE t1 MODIFY LOB(a) ( COMPRESS HIGH ); Enable lob compression on a SECUREFILE LOB column within a single partition. ALTER TABLE t1 MODIFY PARTITION p1 LOB(a) ( COMPRESS HIGH );
DBMS_LOB Package → LOBs inherit the LOB column settings for deduplication, encryption, and compression, which can also be configured on a per-LOB level using the LOB locator API. However, the LONG API cannot be used to configure these LOB settings. DBMS_LOB package additions for these features are described in the following sections. See Also: Oracle Database PL/SQL Packages and Types Reference, DBMS_LOB package. DBMS_LOB.GETOPTIONS