Re: how to increase extent size
From: Robert Pereira <robert_at_bytesize.ftech.co.uk>
Date: 1995/08/06
Message-ID: <403de7$8ln_at_mars.ftech.co.uk>#1/1
Date: 1995/08/06
Message-ID: <403de7$8ln_at_mars.ftech.co.uk>#1/1
When creating a table, there is a MAXEXTENTS number assigned to it.
If not explicity defined then it takes on the value of the Tablspace
MAXEXTENTS (ME)
DBAs try to keep tables from hitting the ME number when they grow
over time. Exporting the table(s) and saying YES to the question
'Compress extents' is the way to squash everything back down to
1 extent, You then need to drop all the table(s) in the DB
and re-import the DMP file.
Good luck
Robert
Received on Sun Aug 06 1995 - 00:00:00 CEST