Bug report #13473
oracle show 0 when asked for 'show feature count' in layer list
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: |  Jürgen Fischer | ||
| Category: | Data Provider/Oracle | ||
| Affected QGIS version: | master | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | invalid |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 21520 |
Description
see title and screenshot
I loaded a shp file with 354 features in oracle via ogr2ogr
Loaded both the shp and the table in oracle, and in the layer manager/list asked 'Show feature count' in context menu.
As you can see it shows zero, BUT the features are ok and visible...
Related issues
History
#1
Updated by Jürgen Fischer over 8 years ago
- Status changed from Open to Feedback
Are you using estimated metadata data and is the table analyzed? Otherwise Oracle claims that the number of rows is 0.
If
SELECT num_rows FROM all_tables WHERE owner='SOMEONE' AND table_name='SOMETABLE';
returns 0, although the table isn't empty it should change after running
ANALYZE TABLE sometable COMPUTE STATISTICS;
If you get ORA-38029 you should run
exec DBMS_STATS.UNLOCK_TABLE_STATS('SOMEUSER','SOMETABLE');
first.
#2
Updated by Giovanni Manghi over 8 years ago
- Resolution set to invalid
- Status changed from Feedback to Closed
closing for lack of feedback.