Your data goes into the datafile in blocks of "db_block_size" size. A block may contain more than one row. In addition, Oracle maintains a list of blocks that are free. Once you have moved your highwater mark by inserting 1M rows, your data can go in any of the blocks that are on the free list.




Reply With Quote