1. Database Sample Schemas
  2. Sample Schema Scripts and Object Descriptions
  3. PM Sample Schema Scripts and Objects

4.6 PM Sample Schema Scripts and Objects

This section lists the names of the scripts that create the Product Media (PM) schema and describes the objects in the schema. Table 4-19 lists the PM scripts in alphabetical order, while Table 4-20 lists its objects. Note that the SQL*Loader data file pm_p_lob.dat contains hard-coded absolute path names that have been set during installation. Before attempting to load the data in a different environment, you should first edit the path names in this file.

Table 4-19 PM Schema Scripts

Script Name Description

pm_analz.sql

Gathers statistics on the PM objects

pm_cre.sql

Creates the PM objects

pm_drop.sql

Drops schema PM and all its objects

pm_p_ord.sql, pm_p_lob.sql, pm_p_lob.ctl, pm_p_lob.dat

Populates the objects in the schema

pm_main.sql

Main script for schema PM, which calls other scripts

Table 4-20 PM Sample Schema Objects

Object Type Objects

Index

PRINTMEDIA_PK, SYS_C003538

Lob

SYS_LOB0000045882C00003$$, SYS_LOB0000045882C00017$$, SYS_LOB0000045882C00019$$, SYS_LOB0000045882C00034$$, SYS_LOB0000045882C00042$$, SYS_LOB0000045882C00054$$, SYS_LOB0000045882C00062$$, SYS_LOB0000045882C00069$$, SYS_LOB0000045882C00071$$, SYS_LOB0000045882C00080$$, SYS_LOB0000045907C00003$$, SYS_LOB0000045907C00004$$, SYS_LOB0000045907C00005$$, SYS_LOB0000045907C00006$$, SYS_LOB0000045907C00009$$, SYS_LOB0000045907C00015$$, SYS_LOB0000045908C00004$$

Table

PRINT_MEDIA

Type

ADHEADER_TYP, TEXTDOC_TAB, TEXTDOC_TYP