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