My Oracle Support Banner

R12: Upgrade to 12.2.9 Pat094.odf Fails ORA-39726 (Doc ID 2630480.1)

Last updated on MARCH 23, 2023

Applies to:

Oracle Project Foundation - Version 12.2.9 and later
Information in this document applies to any platform.

Goal

During upgrade to 12.2.0 and 12.2.9 patch failed in
ATTENTION: All workers either have failed or are waiting:

  FAILED: file pat094.odf on worker 9.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Error was:
ALTER TABLE PA.PA_COST_DISTRIBUTION_LINES_ALL ADD ( AMOUNT#1 NUMBER DEFAULT  0 NOT NULL )

AD Worker error:
The following ORACLE error:

ORA-39726: unsupported add/drop column operation on compressed tables


Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.