2.2.2 Set up Target Schema

This topic gives the instructions to set up Target Schema.

You need to set up the target schema. For the purpose of illustration, let us consider a schema by name DESTSCHEMA.

You can use the Oracle FLEXCUBE Investor Servicing Installer to set up the target schema.

Follow the steps given below:

1. Create the target version database using the target version Installer.
   Refer to the Installation manual of the required version for details on setting up database.
2. Load the static data using installer. Refer to the installation manual of the required version for details on loading static data.
3. Exit the installer immediately after loading the static data.
   The basic setup step should not be done through the installer. At this point all data structures will be in place and static data tables will have the data populated as of the target version. But all schema objects like the source packages, triggers, procedures, functions, constraints, indexes, views, sequences, etc. would be available as of the base Kernel version.
4. If there are any customization changes that needs to retro-fitted in the target version schema, you may compile them now. You can also make the related static data changes. While doing the TEMPSOFT changes, you need to take care of the following:
   1. If the source version had an additional column with data, you need to manually move the same as the import of data from production has already been done.
   2. Apply the additional static data onto the upgraded schema.
5. You need to create a dummy schema in the same oracle instance as that of target schema.
   The dummy schema will have the same name as that of the source schema (from which dump was exported). Provide necessary grants for import/export. This is necessary to connect and import data later on from the dump.