Dbchck errors - Mismatch between Physical and Dictionary schema (Doc ID 1332810.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

Customer Environment:   8.1.1.4 [21225] version, System Admin

When attempting to use tables in mappings or applying schema changes mismatch issue notified.

ERROR
-----------------------
Error: Dictionary for S_ACT_EMP different from physical schema1    Dictionary different from physical schema for index

Note: Both dictionary columns are modified to SYS_NC00030$ and SYS_NC00031$ when querying DBA_IND_COLUMNS at database level.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run  DBchck utility, Dbchck log contains failed errors

dbchck: S_ACT_EMP checking completed: 2 checks failed.
dbchck: S_ADDR_ORG checking completed: 1 check failed.
dbchck: S_ASSET_WRNTY checking completed: 1 check failed.
dbchck: S_CONTACT checking completed: 1 check failed.
dbchck: S_EVT_ACT checking completed: 7 checks failed.
dbchck: S_ORG_EXT checking completed: 1 check failed.
dbchck: S_ORG_PROD checking completed: 1 check failed.
dbchck: S_PAY_METHOD checking completed: 1 check failed.
dbchck: S_PAY_PLAN checking completed: 2 checks failed.
dbchck: S_PROD_INT checking completed: 2 checks failed.
dbchck: S_PRSP_CONTACT checking completed: 1 check failed.
dbchck: S_SRC_PAYMENT checking completed: 2 checks failed.
dbchck: Checking completed: 22 checks failed in 12 tables.

Cause

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