Ram Dittakavi, October 01, 2017 - 5:03 am UTC
Refered wiki http://www.orafaq.com/wiki/ROWID not 100% correct
Marc Martens, October 10, 2017 - 8:24 am UTC
It says that from Oracle 8 onwards the block number (in the new rowid format) has a maximum value of (2**20=1M).
How can that be? With a block size of 8K that would result into a maximum file size of 8G ... however we all know that the max file size with 8K blocks is 32G, so the block number should have 22 bits and not 20 as stated on the Wiki.
October 10, 2017 - 2:07 pm UTC
Yeah, they got their carve up of the bits slightly wrong.
You get a ceiking of 4194304 blocks in a (smallfile) datafile, so typically this means 32G for an 8k block size.