Compatibility and Migration Issues

The following LOB related compatibility and migration issues are described in detail in Oracle9i Database Migration :

• "Varying Width Character Sets for CLOBs or NCLOBs", under "Datatypes, Compatibility and Interpretability Issues".

• Downgrading with CACHE READs Defined: See "Downgrading to an Older Version 8 Release", under "Remove Incompatibilities", "Datatypes", "Discontinue Use of Cache Reads Specified for LOBs".

• Downgrading -- Removing LOB Columns from Partitioned Table: See the chapter, "Downgrading to an Older Version 8 Release", under "Remove Incompatibilities", "Datatypes", "Remove LOB Columns from Partitioned Tables".

• Downgrading -- LOBs and Varrays in Index Organized Tales: See "Downgrading to an Older Version 8 Release", under "Remove Incompatibilities, "Schema Objects", "Discontinue Use of LOBs and Varrays in Index Organized Tables".

• Downgrading --Varying Width Character Sets for CLOBs or NCLOBs: See the c hapter, "Downgrading to an Older Version 8 Release", under "Remove Incompatibilities", under "Datatypes", "Remove CLOBs and NCLOBs from Tables in Database with Varying-Width Character Set".

• Downgrading -- Partitoned Index Organized Tables (PIOTs) (on LOBs): See the chapter, "Removing Oracle9i Incompatibilities".

• Downgrading -- Functional Indexes on LOBs: See the chapter, "Removing Oracle9i Incompatibilities".

• Downgrading -- LONG to LOB data and application migration: See the chapter, "Removing Oracle9i Incompatibilities".