You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for SecureFiles


1 to 20 of 477 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database New Features Guide, 11g Release 1 (11.1)

Oracle 11g Database New Features

1.6.1 Oracle SecureFilesOracle SecureFiles. Enhancements include built-in compression and encryption.

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Database SecureFiles and Large Objects Developer's Guide - Contents

ContentsPart 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

Oracle C++ Call Interface Programmer's Guide, 11g Release 1 (11.1)

Programming with LOBs

Using SecureFilesStarting 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

Database Security Guide, 11g Release 1 (11.1)

What's New in Oracle Database Security?

Intelligent LOB Compression, Deduplication, and Encryption with SecureFilesSecureFiles. 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

Database JDBC Developer's Guide and Reference, 11g Release 1 (11.1)

What's New

Oracle SecureFilesJava/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\".

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

Storage of SecureFilesThis 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

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

Initialization Parameter for SecureFilesThe db_securefile parameter is set in the file init.ora:

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

4 Using Oracle SecureFilesThis 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

Database Readme, 11g Release 1 (11.1)

Oracle® Database Readme

42.21 Oracle SecureFiles Known BugsBug 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 (11.1.0.7.0). Bug 6191877 Executing ALTER TABLE MOVE with SecureFile LOBs encrypted fails with internal errors. Workaround:  Drop the table after exporting

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

Parameters for CREATE TABLE With SECUREFILE LOBscompatibility 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

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

Parameters for ALTER TABLE With SECUREFILE LOBsfrom BasicFile LOBs to SecureFiles\" Oracle Database SQL Language Reference ALTER TABLE statement

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

ALTER TABLE Examples for DeduplicationDisable 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 );

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

Compatibility and Upgradingdisk space required. Note that Streams does not support SecureFiles in the current release.

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

Online Redefinition for BasicFilesOnline redefinition is the only recommended method for migration of BasicFile LOBs to SecureFiles

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

CREATE TABLE Usage Notes for EncryptionCreate 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

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

PL/SQL Packages for SecureFiles: Column SettingsThe column settings packages for SecureFiles are outlined.

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

Preventing Generation of Redo Space when Migrating to SecureFile LOBsGeneration 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

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

CREATE TABLE Usage Notes for Deduplicationtables on a per-partition basis. Deduplication is applicable only to SecureFiles. DBMS_LOB.SETOPTIONS

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

ALTER TABLE Usage Notes for CompressionHIGH setting incurs more work, but will compress the data better. The default is MEDIUM. LOB compression is applicable only to SecureFiles.

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Using Oracle SecureFiles

CREATE TABLE Examples for DeduplicationCreate 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)