[Q] Increasing size of tablespaces

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, and the tablespace has now reached the maximum number of extents allowed under SunOS.

Question: what is the quickest way to fix this problem? Doing a full export, recreating the database, and then importing seems like an option, but this would be *EXTREMELY* time consuming. Is there a better way? What about dropping all the indexes and primary keys, recreating the tablespace, and then re-indexing everything? Any other ideas?

--
Ken Bobey, ISA Corp.                Internet: ken_at_edm.isac.ca
#835 10040-104 Street               TEL: 403-420-8081 x8997 x5666
Edmonton, AB, Canada T5J 0Z2        FAX: 403-420-8037 x8026