user_tab_cols is not synchronize with real table definition?

Rohit Jadhav-Oracle

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.

Suresh Sangaran-Oracle

Hello Rohit,

This space is for FMW Oracle Reports product. For database questions you may raise your query in

https://community.oracle.com/tech/developers/categories/3063-general_questions

Regarding your issue, run ANALYZE for the tables and check the views.

Thanks, Suresh

Rohit Jadhav-Oracle

I ran this :

ANALYZE TABLE CI_ACCT COMPUTE STATISTICS;

No change in views, result is same as before.

Thanks I will take the issue on Oracle forum