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


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

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.


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.

Tim... said...


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.



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
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired