Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Empty fragments in tablespaces

Empty fragments in tablespaces

From: Didier <Didier.Mercadier_at_wanadoo.fr>
Date: Thu, 11 Jun 1998 20:29:23 GMT
Message-ID: <35803de1.3187920@news.wanadoo.fr>


With ORACLE 6, when you create a table and after you drop il, you still have an empty extent that fragments the tablespace. And in time, the tablespace can be empty but you can't allocate a huge initial extent table.
I would like to know from which ORACLE 7 release it is fixed (7.2, 7.3 or more), and if there is solution to force the unfragmentation in previous release.
Than you very much. Received on Thu Jun 11 1998 - 15:29:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US