Null and Not Null value returned in 11g
We have a database initially containing empty tables (there has never been data before).
I would like to obtain storage parameters such as:
pct_free, pct_used, initial_extent, next_extent, min_extents and max_extents.
In order to do that I'm querying user_tables table to retrieve these parameters.
In this case (there has never been data before) I always got NULL.
Tables that contained data returned something not-NULL for all of theme.
If I inserted a value into an empty table, the return values all became not-NULL.
If I deleted all data from a table, the returns values remained not-NULL.
pct_free, pct_used, initial_extent, next_extent, min_extents and max_extents.
In order to do that I'm querying user_tables table to retrieve these parameters.
In this case (there has never been data before) I always got NULL.
Tables that contained data returned something not-NULL for all of theme.
If I inserted a value into an empty table, the return values all became not-NULL.
If I deleted all data from a table, the returns values remained not-NULL.
0