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 PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

Predefined PL/SQL Large Object (LOB) Data TypesOracle Database SecureFiles and Large Objects Developer's Guide for more information about LOBs Topics

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 PL/SQL Language Reference, 11g Release 1 (11.1)

Preface

Related DocumentsDeveloper's Guide Oracle Database SecureFiles and Large Objects Developer's Guide Oracle Database Object

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

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

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 EncryptionCreate 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

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 CompressionSecureFile 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

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 CompressionDisable 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 );

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

Using Oracle SecureFiles

DBMS_LOB PackageLOBs 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

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

Using Oracle SecureFiles

Parallel Online Redefinition( ASSM) enabled, which is now the default and is a requirement for SecureFiles. There is a simple mapping