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. 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.

PM Sample 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

PM Sample Schema Objects

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