Friday, December 11, 2020

Creating and maintaining Custom Tables in R12.2.x

 1. To create a custom table in custom schema – XXCUSTOM CREATE TABLE XXCUSTOM.TABLE_NAME (COL1 NUMBER,….);2. To generate editioning view and synonym for the table execute below scriptexec AD_ZD_TABLE.UPGRADE('XXCUSTOM','TABLE_NAME');This will create two new objects: (i) An editioned view (having # in the end) in XXCUSTOM schema (e.g. XXCUSTOM.TABLE_NAME#) (ii) A synonym (same as table_name)...
Share: