Re: [Q] Increasing size of tablespaces
From: DavidJRoth <davidjroth_at_aol.com>
Date: 22 Dec 1994 22:25:51 -0500
Message-ID: <3ddfvv$3jh_at_newsbf02.news.aol.com>
Date: 22 Dec 1994 22:25:51 -0500
Message-ID: <3ddfvv$3jh_at_newsbf02.news.aol.com>
The initial extent and next extent that you specify when creating a
tableapace aer default values. You can specify new values on an index by
index bases.
Instead of drop all indexes you can just drop the bigest ones.
Are you sure that you have hit the max extents limit? The message you get when you are out of space in the tablespace or when the tablespace is badly fragmented is very similar? Received on Fri Dec 23 1994 - 04:25:51 CET