Re: Why assign a size to a tablespace ?
From: Ian Funnell <ian_at_icf0.demon.co.uk>
Date: 1996/11/18
Message-ID: <HErH9BAjXOkyIwJQ_at_icf0.demon.co.uk>#1/1
Date: 1996/11/18
Message-ID: <HErH9BAjXOkyIwJQ_at_icf0.demon.co.uk>#1/1
In article <aak2.848302317_at_Isis.MsState.Edu>, Atif Ahmad Khan
<aak2_at_Ra.MsState.Edu> writes
>
>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 ?
You must specify an initial size for datafiles/tablespaces, but these can be set to expand automatically as required.
Use Oracle's "Server Manager" to get statistics on sizing etc.
Hope this helps.
-- Ian Funnell ian_at_icf0.demon.co.ukReceived on Mon Nov 18 1996 - 00:00:00 CET