LOB "Demo" Directory

LOB examples are provided in this manual in Chapters 5, 7, 9, 10, and 11 primarily. The vast majority of these scripts have been tested and run successfully. Syntax for setting up the sample multimedia schema is described in Appendix B, "The Multimedia Schema Used for Examples in This Manual", and also in:

• Chapter 10, "Internal Persistent LOBs", under "Creating a Table Containing One or More LOB Columns" on

• Chapter 11, "Temporary LOBs", under "Creating a Temporary LOB"

• Chapter 12, "External LOBs (BFILEs)", under "Creating a Table Containing One or More BFILE Columns"

• In the $ORACLE_HOME/rdbms/demo/ directory in the following files:
  • lobdemo.sql

  • adloci.sql.

Location of Demo Directories?

Many of the examples for the use cases are also available with your Oracle9i installation at the following location:

• Unix: On a Unix workstation, at $ORACLE_HOME/rdbms/demo/lobs/

• Windows NT: On Windows NT, at $ORACLE_HOME\rdbms\demo\lobs