8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for SecureFiles : Large Objects (LOBs) in Oracle 11g Database Release 1


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

Max said...

>> Oracle Streams does not currently support SecureFiles, so avoid mig
It is wrong for 11.2, because:
Oracle Streams does not support SecureFiles LOBs that are deduplicated
http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#CIHJIDGE

Max said...

Capture processes can capture changes to SecureFile LOB if compatibility is set to 11.2.0.0
capture processes do not support capturing changes to SecureFile LOB columns stored using deduplication, capturing changes resulting from fragment-based operations on SecureFile LOB columns

Tim... said...

Hi.

The article was written against 11gR1, but I've added a comment about that change in 11gR2.

Thanks for the feedback.

Cheers

Tim...

Javid Hasanov said...

Dear Tim,

Thank you for great article!

I just want to mention one point. It's incomprehensible that the value "FORCE" for initialization parameter db_securefile not indicated in oracle 11.1, 11.2 and 12.1 and 12.2 Reference docs.

But it's indicated in Database SecureFiles and Large Objects Developer's Guide => Initialization Parameter for SecureFiles

Tim... said...

Hi.

Strange that isn't it. :) I've amended the list to include some minor changes with 12c, but it's basically the same.

Cheers

Tim...

Javid Hasanov said...

Thank you Tim.

I like the way You explain things :)

And it would be wonderful if you will add article about enhancements with SecureFiles in 12c like "Oracle Datapump supports SecureFiles as Default", "Parallel DML supported for LOB stored as SecureFiles on a non-partitioned table".

Tim... said...

Hi.

I've added it to the list. :)

Cheers

Tim...

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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.