ORA-01502 (Index or Partition of Such Index is in Unusable State) on OGG DDL Objects
(Doc ID 1358765.1)
Last updated on MAY 02, 2016
Applies to:Oracle GoldenGate - Version 9.5_EA to 220.127.116.11.0 [Release 9.5.0 to 18.104.22.168]
Information in this document applies to any platform.
Receiving following errors on Oracle GoldenGate (OGG) DDL related objects when executing any DDL statements on a database where DDL replication is enabled:
ORA-01502: index '<object name>' or partition of such index is in unusable state
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