My Oracle Support Banner

Autoupgrade fails with error "ORA-00904: "DDL_OFFSET": invalid identifier" (Doc ID 2814165.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 Autoupgrade fails with below error when upgrading PDB$SEED -

11:12:46 SQL>
11:12:46 SQL> ALTER TABLE gsmadmin_internal.cloud ADD
11:12:46 2 ddl_offset NUMBER DEFAULT 0
11:12:46 3 /

ERROR at line 1:
ORA-00904: "DDL_OFFSET": invalid identifier
ORA-06512: at line 35

 autoupgrade_<TimeStamp>.log : 

DATABASE NAME: DEV-PDB$SEED
CAUSE: ERROR at Line 18219 in [/u01/app/oracle/autoupgrade/DEV/DEV1/104/dbupgrade/catupgrd20210722101103pdb_seed0.log]
REASON: ORA-00904: "DDL_OFFSET": invalid identifier
ACTION: [MANUAL]
DETAILS: 00904, 00000, "%s: invalid identifier"
// *Cause:
// *Action:

   

Cause

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
Symptoms
Cause
Solution


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