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