Friday, November 6, 2015

Statndard tables columns are missing, 12.2 Upgrade


Their is sync missing between original synonym and the Edition View.

Expected in Upgrade 12.2

Use Upgrade Procedure for a table to be in sync with Edition View

SQL> exec ad_zd_table.upgrade(table_owner, table_name);


How to Add a Column:


Altering a table – Adding Columns and Indexes

1.  Alter table in custom schema the usual way.
alter table cust_table add cust_sex varchar2(1) NOT NULL;

Regenerate the editioning view using AD_ZD_TABLE.PATCH

SQL> exec ad_zd_table.patch(table_owner, table_name);

NB: Once the table is altered with the table name, “exec ad_zd_table.patch(‘XXSDS’, ‘XXSD_EMPLOYEE’)” needs to be applied every time


Then:

exec ad_zd_table.upgrade(table_owner, table_name);


Report# adzddbcc.lst

DOC>  EBS Online Patching Database Compliance Checker
DOC>  $Header: ADZDDBCC.sql 120.13.12020000.61 2015/03/03 13:10:21 seetsing ship $
DOC>  **********************************************************************

Elapsed: 00:04:53.30
DOC>  **********************************************************************
DOC>  SECTION-20
DOC>  **********************************************************************
DOC>  "Table must have an Editioning View"
DOC>
DOC>   - P2: These tables may not be patched using Online Patching
DOC>   - Fix violations by calling the table upgrade procedure:
DOC>       SQL> exec ad_zd_table.upgrade(table_owner, new_table_name)
DOC>   - Note: Tables that end with "_A" are typically audit tables
DOC>           by the Audit Trail feature, and can be ignored.
DOC>#

OWNER            NAME
---------------- ------------------------------
APPLSYS          TXK_TCC_RESULTS

Perform the below.
$ sqlplus system/****@$TWO_TASK
SQL> alter session set current_schema=APPS; 
SQL> exec ad_zd_table.upgrade('APPLSYS', 'TXK_TCC_RESULTS'); 
SQL> commit;
2. Re-run Online Patching Readiness Report. 


No comments:

Post a Comment