the problem is no. of extents
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 ?
Re: the problem is no. of extents
First you try to provide the sufficient space for that tablespace on your server by delete some unnecesary files or moving some files to another location then you try to create the index
The Syntax for allocating unlimited quota to a tablespace is:
alter tablespace quota unlimited
Cheer ...
Quote:
Originally posted by anjandg
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 ?