Forum Stats

  • 3,837,266 Users
  • 2,262,245 Discussions


user_tab_cols is not synchronize with real table definition?

Rohit Jadhav-Oracle
Rohit Jadhav-Oracle Member Posts: 35 Employee
edited Aug 2, 2022 10:53PM in Reports

Oracle 19c

I see nullable field in user_tab_cols /all_tab_columns is not same as table definition

example :

if column is not null on table definition then it must be shown as 'N' in above mentioned tables instead it show's up 'Y'. I have to run alter 1st null and then not null and then the value gets correctly seen in tables.

Screen shot attached.