Re: Locally Managed Tablespaces

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <rlsmith@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Jan 2005 15:19:00 -0500

why not use system allocation sizes?
extent management local autoallocate
If tables are going to be a variety of different sizes this should work
fine. I use it pretty much everywhere because no one ever has any idea how
big their tables will get.

You danger, no matter what you do is the originator will throw out some
wacky initial extent size, like 10Gb and only have one row. Oracle will go
with their inital but ignore the next.


Other related posts: