完成移轉後活動

移轉工作順利完成之後，請完成下列移轉後活動。

更新表格並驗證 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;