Re: [Q] Increasing size of tablespaces

DOS System Administrator (dosadmin_at_glory.edm.isac.ca) wrote:
: We are running an Oracle 7.0.15.4 database with about 10 million
: records. It is heavily indexed to improve query performance.
 

: The data and indexes are stored in separate tablespaces. Recently
: we started getting ORA-01547 errors (failed to allocate extent
: size X in tablespace Y) for the tablespace holding the indexes.
: The problem is that the tablespace was created with an initial
: extent of 1M and next extent of 1M. This is too small.
 

: Question: what is the quickest way to fix this problem?

You should be able to simply drop all of the indexes and recreate them with the proper sizing parameters, and be back in business. However, you may still need to add a datafile to the tablespace to increase space.

--
=================================================================
Gary T. Smith                | My opinions are strictly my own.
smithg2_at_iia.org              |
=================================================================