Re: Relocating LOB segment
From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 06 Feb 2015 15:26:47 +0000
Message-ID: <1046726819.978337.1423236406587.JavaMail.yahoo_at_mail.yahoo.com>
> If you are on 11.2 and use SecureFiles then you can export with parallel
It actually started at 11.1.
Now I have a question. Can anybody think of anything bad about setting db_securefile to always in Oracle 11g so all LOBs are created as SecureFile instead of BasicFile? We're recommended to use SecureFile LOB (see Doc 1467662.1 and many others), and it's the default in 12c. Other than the restriction that SecureFile LOB can't be created in a non-ASSM i.e. MSSM tablespace, I see only benefit, no disadvantage. Without the advanced security or compression license, users have to be careful not to accidentally add certain clauses to trigger usage of these licenses. But that's a minor concern. Yong Huang
Date: Fri, 06 Feb 2015 15:26:47 +0000
Message-ID: <1046726819.978337.1423236406587.JavaMail.yahoo_at_mail.yahoo.com>
> If you are on 11.2 and use SecureFiles then you can export with parallel
It actually started at 11.1.
Now I have a question. Can anybody think of anything bad about setting db_securefile to always in Oracle 11g so all LOBs are created as SecureFile instead of BasicFile? We're recommended to use SecureFile LOB (see Doc 1467662.1 and many others), and it's the default in 12c. Other than the restriction that SecureFile LOB can't be created in a non-ASSM i.e. MSSM tablespace, I see only benefit, no disadvantage. Without the advanced security or compression license, users have to be careful not to accidentally add certain clauses to trigger usage of these licenses. But that's a minor concern. Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 06 2015 - 16:26:47 CET