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