Re: Why assign a size to a tablespace ?

Atif Ahmad Khan 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 ?
>
> Currently I have an error that I think is a space related
> problem too, as I am trying to insert some data into a table
> and this error isn't letting me do it :
>
> -------------
> insert into testdb
> *
> ERROR at line 1:
> ORA-01652: unable to extend temp segment by 315 in tablespace SYSTEM
> -------------

  You can use ALTER TABLESPACE tbs DEFAULT STORAGE ... to change the maxextent to avoid the above error. Besides, you can prevent to fix the size of a tablespace by using AUTOEXTEND ON when you create a tablespace.  

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841