I can't add space on that tablespace as there is no space left in the server. If I see the dba_tablespaces, the maximum no. of extents for that particular tablespace is 505. Now I want to create an index on that tablespace giving initial extent 10240K and next_extent 10240K. After sometime it gives an error similar to 'maximum no. of extent (505) reached for the tablespace' . While creating a tablespace the default is set for maximum no. of extents. Can it be changed to UNLIMITED by issuing an alter tablespace statement ? It it can be changed, what will be the syntax ?