Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Worker failing while applying Patch 13405137

edited Aug 19, 2013 7:10PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered
Hi Team,


While applying Patch in one of the Dev instance adpatch is failing with below error:

In table ASO_QUOTE_HEADERS_ALL, the column QUOTE_NAME
has the wrong size.

The column currently has size:
QUOTE_NAME VARCHAR2(80)
and should have size:
QUOTE_NAME VARCHAR2(240)

Modify the column with the statement:


Start time for statement below is: Sun Aug 18 2013 06:09:01

ALTER TABLE ASO.ASO_QUOTE_HEADERS_ALL MODIFY ( QUOTE_NAME VARCHAR2(240) )

AD Worker error:
The following ORACLE error:

ORA-30556: either functional or bitmap join index is defined on the column to be modified


occurred while executing the SQL statement:

ALTER TABLE ASO.ASO_QUOTE_HEADERS_ALL MODIFY ( QUOTE_NAME VARCHAR2(240) )

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center