SQL & PL/SQL

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!

regarding BLOCKS column in USER_TAB_PARTITIONS view

Sa SiMar 10 2020 — edited Mar 11 2020

I have a table which is partitioned, when i queried a specific partition there were no rows in that partition, but, when i looked into USER_TAB_PARTITIONS view for that specific partition, NUM_ROWS was 0 and BLOCKS was 2147483. May i know why BLOCKS is 2147483 and what does it mean ? any insights would be helpful.

This post has been answered by Solomon Yakobson on Mar 10 2020

Jump to Answer

Added on Mar 10 2020

14 comments

1,226 views