Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

user_tab_cols is not synchronize with real table definition?

Rohit Jadhav-OracleAug 2 2022 — edited Aug 2 2022

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.
image.png
image.png

Comments
Post Details
Added on Aug 2 2022
2 comments
244 views