Complete Post Migration Activities

After the migration job completes successfully, complete the following post migration activities.

Update Tables and Validate PeopleSoft Schema Objects

1. Populate the PSDBOWNER table for DBName. Insert DBName and OwnerID values to the PSDBOWNER table.

   SQL> INSERT INTO PS.PSDBOWNER VALUES ('HR9246','SYSADM');
   SQL> col DBNAME format a30
   SQL> col OWNERID format a20
   SQL> SELECT * FROM PS.PSDBOWNER;

2. Validate the object count of PeopleSoft schemas by running the object count at the source database.

   SQL> col OWNER format a20
   SQL> col OBJECT_TYPE format a40
   SQL> SELECT OWNER, OBJECT_TYPE, COUNT(*)
        FROM ALL_OBJECTS
        WHERE OWNER IN ('PS','PEOPLE','SYSADM') GROUP BY  OWNER, OBJECT_TYPE ORDER BY 1,2;

3. Validate the object count of PeopleSoft schemas by running the object count at the target database.

   col OWNER format a20
   col OBJECT_TYPE format a40
   SELECT OWNER, OBJECT_TYPE, COUNT(*) 
   FROM ALL_OBJECTS 
   WHERE OWNER IN ('PS','PEOPLE','SYSADM') GROUP BY  OWNER, OBJECT_TYPE ORDER BY 1,2;

Validate PeopleSoft Schema Objects

Validate the object count of PeopleSoft Schemas by running the object count at the source and target databases.

1. Run object count at the source database.

   SQL> col OWNER format a20
   SQL> col OBJECT_TYPE format a40
   SQL> SELECT OWNER, OBJECT_TYPE, COUNT(*)
        FROM ALL_OBJECTS
        WHERE OWNER IN ('PS','PEOPLE','SYSADM') GROUP BY  OWNER, OBJECT_TYPE ORDER BY 1,2;

2. Run object count at the target database.

   col OWNER format a20
   col OBJECT_TYPE format a40
   SELECT OWNER, OBJECT_TYPE, COUNT(*) 
   FROM ALL_OBJECTS 
   WHERE OWNER IN ('PS','PEOPLE','SYSADM') GROUP BY  OWNER, OBJECT_TYPE ORDER BY 1,2;