Find After Takeover Production Data Step - All Varchar2 Columns Having Doubled Value in Size (Doc ID 2015432.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.3.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
Find after takeover all varchar2 fields on database are doubled in size
e.g. field varchar2 (40 char) is now varchar2 (80 char)

Expected Behavior
Correct data type after takeover equal to origin table

Steps
1. Configure Upgrade tool and run all necessary steps up to takeover
2. Define takeover tables
3. Run takeover
4. Check table columns on source DB schema (prod) and target DB schema with sqlplus describe command

Find old origin value for T_MASTER_DAT table column on source DB
ICON   VARCHAR2 ( 40 CHAR )
CMG_CTRL  VARCHAR2 ( 1 CHAR )


Find new value value for T_MASTER_DAT table column on target DB
ICON   VARCHAR2 ( 80 CHAR )
CMG_CTRL  VARCHAR2 ( 2 CHAR )

Changes

Upgrade from Agile e6.1.1 to Agile e6.1.3

Cause

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