| 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 ‘DIRECTORY’,
‘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. |
| ELCM_Triggers_Enable.sql |
| /SOFT/TOOLS/Upgradetoolkit/Soft/ImpExp/Scripts |
| Script to enable ELCM
related tables. |
| ELCM-TriggersEnable.sql |
| SOFT/TOOLS/Upgradetoolkit/Soft/Migration/LM-EL/Scripts |
| Script to enable ELCM
related triggers. |
| ELCM_TRUNCATE.sql |
| SOFT/TOOLS/Upgradetoolkit/Soft/Migration/LM-EL/Scripts |
| Script to truncate the
ELCM database |
| LM_EL_MIG_STUB.sql |
| SOFT/TOOLS/Upgradetoolkit/Soft/Migration/LM-EL/Scripts |
| Script to call the package
‘ELPKS_LM_REPLICATION’ which migrates LM data to GE. |