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

Processing

Post Details

Added on Aug 2 2022
2 comments
240 views