Re: Why assign a size to a tablespace ?

Atif Ahmad Khan (aak2_at_Ra.MsState.Edu) wrote:

> I am just wondering why does oracle require that you assign
> a size to table/tablespace ? When you do it immediately
> takes up that much disk space. Why can't it be dynamic ?

I agree with the feelings of flexibility with dynamic sizing, but something you might want to consider is how the other approach might work. By default when you create a tablespace in Oracle the disk space is allocated - so if you fill up the tablespace you have to re-size (to get more disk space).

The aother approach would be to dynamically grow - no more need to re-size. However it also means that you don't have *guaranteed* disk space - you can get a situation where your tablespace wants to grow but there's no disk space for it to grow into.

I'm not saying the latter is inherently bad - just an alternative approach with different issues and different ways of managing those issues.

Matt Received on Tue Nov 19 1996 - 00:00:00 CST