GETOPTIONS Functions
--------------------------------------
This function obtains compression, deduplication, and encryption settings
corresponding to the option_type field for a particular LOB.
SETOPTIONS Procedures
----------------------------------------
This procedure enables/disables compression and deduplication on a per-LOB basis,
overriding the default LOB column settings.
Oracle recommends that you enable compression, deduplication, or encryption through the CREATE TABLE statement. If you enable these features through the ALTER TABLE statement, all SecureFiles LOB data in the table is read, modified, and written; this causes the database to lock the table during a potentially lengthy operation.
On second thought I think B sounds better. The documentation says SETOPTIONS works on individual SecureFiles and doesn't say anything about working on entire columns. I don't think it's C anymore since the option is called DEDUPLICATE, not DUPLICATE.
upvoted 2 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Rakeshpro
2 years, 4 months agoRakeshpro
2 years, 4 months agochrishillinger
2 years, 5 months agoCosminCof
4 years, 2 months agojcamt
4 years, 4 months agotassicek
4 years, 11 months agoZayas
5 years agoorakell
5 years, 2 months agoorakell
5 years, 2 months ago