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;
SQL> exec ad_zd_table.upgrade('APPLSYS', 'TXK_TCC_RESULTS');
SQL> commit;
2. Re-run
Online Patching Readiness Report.
No comments:
Post a Comment