Work Plan -- Apply Changes to TSTARCHP/TSTP

Apply changes to TSTARCHP/TSTP

1. Preparation of scripts

2. RMAN cold backup TSTARCHP

3. Apply scripts (In TSTARCHP)

cd
/u01/app/oracle/admin/TSTARCHP/create/chg2007-05-22/db_r147_combined_tst
archp/ddl
Login as SYSTEM, execute the following control script to alter table
columns.
alter_arch_unix.sql

Note: some errors found in the log
------------------
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-02443: Cannot drop constraint - nonexistent constraint
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-02443: Cannot drop constraint - nonexistent constraint
ORA-00904: invalid column name
ORA-00904: invalid column name
ORA-02262: ORA-%05d occurs while type-checking column default value
expression
ORA-01418: specified index does not exist
ORA-01418: specified index does not exist
ORA-02443: Cannot drop constraint - nonexistent constraint
-------------------

4. Apply this latest version of a trigger (In TSTP)
cd /oracle/admin/TSTP/create/chg2007-05-22
log in as DEV, execute
DEV.ARCH_CF_INVOICE_LINE_ITEM_TRG_ddl.sql

Problem:
--------

SQL> @DEV.ARCH_CF_INVOICE_LINE_ITEM_TRG_ddl.sql
CREATE OR REPLACE TRIGGER arch_cf_invoice_line_item_trg
*
ERROR at line 1:
ORA-04054: database link TSTARCH does not exist

Fix
---
Change TSTARCH to TSTARCHP

5. Recompile triggers starting with ARCH_*. (In TSTP)