5 Annexure

This topic provides the details of utility scripts used in the upgrade process.

Utility Scripts

The utility scripts are given in the following table:

Table 5-1 Utility Scripts

Script Name	Location	Remarks
Export_Site_FULL_Dump.par	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Param files to export the production schema at site. In this par file, replace the word SOURCESCHEMA with the actual schema name to be exported. Also change the DIREC-TORY, ‘DUMPFILE, LOGFILE names as per the actual names used. This is applicable to all the par files supplied in the document.
Create_DB_Link.sql	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Script to create database link. Before creating the DB link, configure the TNS connection between the source and destination database.
TableDiff_Source_Dest.sql	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Scripts to list out the differences between the source schema and target schema.
Existing_Table_Column_Diff.sql	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Script to list out the differences in tables which are existing in both the schemas, but the columns are different.
Constraint_Trigger_Disable_Script.sql	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Script to disable constraints and triggers.
Constraint_Trigger_Enable_Script.sql	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Script to enable constraints and triggers.
Drop_Sequence_Script.sql	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Script to drop the sequence.
Import_P-M_data.par	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Param files to import static data.
Import_EM_data.par	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Param files to import non- static data.
Import_Sequence.par	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Par file to import sequence.
Truncate_PData.sql	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Scripts to truncate p-Data.
Export_Source_PData.par	/SOFT/TOOLS/ Upgradetoolkit/ Soft/ImpExp/ Scripts	Param file to export required p_data tables.