Worker failing while applying Patch 13405137
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) )