Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
user_tab_cols is not synchronize with real table definition?

Rohit Jadhav-Oracle
Member Posts: 35 Employee
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.
Answers
-
Hello Rohit,
This space is for FMW Oracle Reports product. For database questions you may raise your query in
Regarding your issue, run ANALYZE for the tables and check the views.
Thanks, Suresh
-
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