4
Managing LOBs

This chapter describes the following topics:

• DBA Actions Required Prior to Working with LOBs

• Using SQL DML for Basic Operations on LOBs

• Changing Tablespace Storage for a LOB

• Managing Temporary LOBs

• Using SQL*Loader to Load LOBs
  • Loading InLine and Out-Of-Line Data into Internal LOBs Using SQL Loader

  • SQL Loader LOB Loading Tips

• LOB Restrictions

• Removed Restrictions

Note: Examples in this chapter are based on the multimedia schema and table Multimedia_tab described in Appendix B, "The Multimedia Schema Used for Examples in This Manual".