Which Script Creates 'EVENT_ESSENTIALS_T' While Upgrade From 6.2 To 6.7_FP1? (Doc ID 408987.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 6.7.0.1.1 and later
HP-UX PA-RISC (32-bit)
Oracle Solaris on SPARC (32-bit)

Goal

 In the RTW 'add_new_tables_67.sql' from $PIN_HOME/upgrade/62_67, the CREATE statement of 'event_essentials_t' is remarked, as below:
===============================================
-- IF (NOT pin_upg_common.table_exists ('event_essentials_t', v_errmsg)) THEN
-- v_ddl_stmt := 'CREATE TABLE event_essentials_t
-- (obj_id0 NUMBER,
-- balances_small VARCHAR2(4000),
-- balances_large CLOB,
-- account_obj_id0 NUMBER)
-- $PIN_CONF_TBLSPACE3 $PIN_CONF_STORAGE_SMALL';
--
-- EXECUTE IMMEDIATE v_ddl_stmt;
-- END IF;

The question is:
Does a user need to uncomment these lines before running the upgrade scripts?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms