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