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
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\".
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:
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
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 (188.8.131.52.0). Bug 6191877 Executing ALTER TABLE MOVE with SecureFile LOBs encrypted fails with internal errors. Workaround: Drop the table after exporting
Parameters for CREATE TABLE With SECUREFILE LOBs → compatibility purposes. RETENTION Under 11 g compatibility for SecureFiles, this parameter name specifies the … means that SecureFiles only log the metadata. This option is invalid for BasicFiles. This setting is … of SecureFiles. CACHE and NOLOGGING are not supported together. CACHE and FILESYSTEM_LIKE_LOGGING are … combines
Parameters for ALTER TABLE With SECUREFILE LOBs → from BasicFile LOBs to SecureFiles\" Oracle Database SQL Language Reference ALTER TABLE statement
ALTER TABLE Examples for Deduplication → Disable deduplication on a SECUREFILE LOB. ALTER TABLE t1 MODIFY LOB(a) ( KEEP_DUPLICATES ); Enable LOB-level deduplication on a SECUREFILE LOB. ALTER TABLE t1 MODIFY LOB(a) ( DEDUPLICATE ); Enable LOB-level deduplication on a SECUREFILE LOB column within a single partition. ALTER TABLE t1 MODIFY PARTITION p1 LOB(a) ( DEDUPLICATE );
Compatibility and Upgrading → disk space required. Note that Streams does not support SecureFiles in the current release.
Online Redefinition for BasicFiles → Online redefinition is the only recommended method for migration of BasicFile LOBs to SecureFiles
CREATE TABLE Usage Notes for Encryption → Create a table with encryption enabled or disabled on a LOB column. The current TDE (Transparent Data Encryption) syntax is used for extending encryption to LOB data types. The LOB must be created with SECUREFILE parameter. Encryption is performed at block level. 'encrypt_algorithm' indicates the name of the encryption algorithm. Valid algorithms are: 3DES168 AES128 AES192 (default) AES256 The column
PL/SQL Packages for SecureFiles: Column Settings → The column settings packages for SecureFiles are outlined.
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 Deduplication → tables on a per-partition basis. Deduplication is applicable only to SecureFiles. DBMS_LOB.SETOPTIONS
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 Deduplication → Create a table with SECUREFILE and LOB-level deduplication: CREATE TABLE t1 ( a CLOB) LOB(a) STORE AS SECUREFILE ( DEDUPLICATE CACHE ); Create a table with a SECUREFILE LOB column and LOB deduplication enabled on only one partition. Only LOBs that belong to partition p1 are deduplicated. CREATE TABLE t1 ( REGION VARCHAR2(20), a BLOB) LOB(a) STORE AS SECUREFILE ( CACHE ) PARTITION BY LIST (REGION)