Re: Why assign a size to a tablespace ?

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.uk