完成迁移后活动

迁移作业成功完成后，请完成以下迁移后活动。

更新表并验证 PeopleSoft 方案对象

1. 填充 DBName 的 PSDBOWNER 表。将 DBName 和 OwnerID 值插入到 PSDBOWNER 表中。

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

2. 通过在源数据库中运行对象计数来验证 PeopleSoft 方案的对象计数。

   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. 通过在目标数据库中运行对象计数来验证 PeopleSoft 方案的对象计数。

   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;

验证 PeopleSoft 方案对象

通过在源数据库和目标数据库上运行对象计数来验证 PeopleSoft 方案的对象计数。

1. 在源数据库上运行对象计数。

   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. 在目标数据库中运行对象计数。

   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;