OCM 11g Preparation - Create and manage LOB segments

In OCM exam they can ask you to do all sort of operations using LOBs. So, be prepared for them. In the docs there are some example PL/SQL blocks that can be used as template. However, read everything and keep in mind:

• Differences between Empty and Null LOB
• Inline and Out-of-Line LOB Storage
• How to retrieve data or locator
• Creating / modifying LOBs in IOT and Partitioned Tables
• LOB Types / BFILE
• PCTVERSION and RETENTION parameters
• Manipulate LOBS using DBMS_LOB.READ / DBMS_LOB.WRITE / DBMS_LOB.COPY

There is a very good presentation about LOB internals, though old, that is important to understand the concepts:

http://pt.slideshare.net/tanelp/oracle-lob-internals-and-performance-tuning

Path to Documentation:

Database SecureFiles and Large Objects Developer's Guide -> 11 LOB Storage
Oracle® Database PL/SQL Packages and Types Reference -> DBMS_LOB

+1