Re: Why assign a size to a tablespace ?
Date: 1996/11/19
Message-ID: <56r4pf$d0n_at_cdn_news.telecom.com.au>#1/1
Atif Ahmad Khan (aak2_at_Ra.MsState.Edu) wrote:
> I am just wondering why does oracle require that you assign
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.
> a size to table/tablespace ? When you do it immediately
> takes up that much disk space. Why can't it be dynamic ?
Matt Received on Tue Nov 19 1996 - 00:00:00 CET