PM Sample Schema Scripts and Objects

This following tables list the names of the scripts that create the Product Media (pm) schema and describe the objects in the schema. Table 4-38 lists the pm scripts in alphabetical order, while Table 4-39 lists the pm 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 must first edit the path names in this file.

Table 4-38 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_main.sql`	Main script for schema `pm`, which calls other scripts
`pm_p_lob.sql`,	Populates the objects in the schema

Table 4-39 PM Sample Schema Objects

Object Type	Objects
Index	`printmedia_pk`, `sys_c003538`
Table	`print_media`
Type	`adheader_typ`, `textdoc_tab`, `textdoc_typ`