Advanced Oracle PL/SQL Programming with Packages

4.6. Summary of Files on Disk

The tables in this section list the scripts contained in subdirectories created by the installation procedure. These are in addition to the individual filenames of the PL/Vision packages listed earlier; note that all filenames are in dot notation, where the first component is the package name (e.g,. PLVvu.code).

4.6.1. Contents of the install Subdirectory

File	Description of Contents
plv*.spb	Bodies of the PL/Vision packages.
plv*.sps	Specifications of the PL/Vision packages.
plvdata.sql	Creates the data structures needed to use PL/Vision. Most of this script consists of a series of INSERT statements to populate the PLV_token and PLV_token_type tables.
plvdpsyn.sql	Drops all public synonyms for PL/Vision objects.
plvdsynl	Drops all private synonyms for PL/Vision objects in a specified account.
plvgrant.sql	Grants access to all PL/Vision objects to the specified account or to PUBLIC.
plvins23.sql	Installs PL/Vision for all PL/SQL Releases 2.3 and above (the f indicates support for File I/O).
plvinst.sql	Installs PL/Vision for all PL/SQL Releases 2.2 and below.
plvinsth.sql	Installs PL/Vision online help text.
plvprem.sql	Removes all PL/Vision packages and code elements.
plvpsyn.sql	Creates public synonyms for all PL/Vision packages.
plvsize.sql	Displays the size of PL/Vision stored code by accessing the USER_OBJECT_SIZE data dictionary.
plvsyn.sql	Creates private synonyms for all PL/Vision packages for the specified account.
plvtrem.sql	Removes all ...