RE: Max Extents Question

From: Brian D. Silverio <bsilverio_at_necc.mass.edu>
Date: Mon, 6 Nov 2000 14:45:43 -0500
Message-Id: <10672.121236@fatcity.com>

Congratulations!
Assuming an 8k block size, the table is 17,386,027,589,920 bytes. That is a 17 Terrabyte table.
So with indexes and work space you have the worlds largest database. Must be about a half a petabyte.

Everyone who suggested reorging the table think about what that would entail!

Don't bother fixing the problem. Just rewrite your resume and get another job at 2X what you are making now.....

Seriously, I doubt this is true, did you check to see if the number of extents is really unlimited? Received on Mon Nov 06 2000 - 13:45:43 CST