Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

SecureFiles in Oracle 11g Database Release 1 - Compress, deduplicate and encrypt LOBs using the new LOB functionality in Oracle 11g.



Lesio said...

Perfect article !

Tomasz said...

Tim
FILESYSTEM_LIKE_LOGGING and NOLOGGING are the same for SecureFiles. The diference between FILESYSTEM_LIKE_LOGGING for SecureFiles and NOLOGGING for BasicFiles is SecureFiles will survive instance crash BasicFiles will not survive.
I think you need to clarify it in this document it could be vey useful.

Regards
Tomasz

Yury said...

> There is no automatic method for migrating a column from a BasicFile to a SecureFile LOB.

Actually there is:
Online redefinition is the only recommended method for migration of BasicFile LOBs to SecureFiles. It can be done at the table or partition level.

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#BABDIEGE

Tim... said...

Hi.

Online table redefinition (which I mentioned in the article) is not an automatic method for conversion. You have to do it manually, like all the other methods I listed.

Cheers

Tim...

Tiger said...

Brilliant and very thoughtful article..Thanks a ton... this help me a lot.. I hope you if possible you could share some examples of performance comparison between securefiles and LOBs

Raghav said...

Nice article. Keep up the good work

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)