From oracle-l-bounce@freelists.org Sun Jun 19 04:41:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5J9f5Lo025704 for ; Sun, 19 Jun 2005 04:41:05 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5J9esNi025683 for ; Sun, 19 Jun 2005 04:40:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 159C21C00B5; Sun, 19 Jun 2005 03:37:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29230-10; Sun, 19 Jun 2005 03:37:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8707A1C004E; Sun, 19 Jun 2005 03:37:24 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C574A9.DCA949B1" Subject: RE: Weekend Crunch Help - Freelist Groups Date: Sun, 19 Jun 2005 10:35:35 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Weekend Crunch Help - Freelist Groups Thread-Index: AcVzhNKzG+Sq2x3ETguNT8n58vRFNgA8fqcwAAx2MuA= From: "Christian Antognini" To: Cc: X-archive-position: 21348 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Christian.Antognini@trivadis.com Precedence: normal Reply-To: Christian.Antognini@trivadis.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.5 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C574A9.DCA949B1 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Ethan =20 >ORA-03237: Initial Extent of specified size cannot be allocated in = tablespace > >Running import from a 9.2.0.4 dump file into a 9.2.0.4 database with a = 8k block size. Keep getting >this error because freelist groups is set to 10 in the import file. If = I take a copy of the >statement and lower the FLG to 4 it works. It is going into a LMT with = a 64K extent size, it is >trying to make a 128K object, however I thought it should just ignore = the storage on the import >file (at least the extent size), how does FLG effect this? The freelist group blocks have to be allocated just after the segment = header block in the *first* extent. Since in your case the extents have = only 8 blocks, you cannot specify 10 freelists groups. You should either = change the size of the extents or lower the number of freelist groups. =20 HTH Chris =20 PS: If I don't reply to further posts on this or others threads, it's = simple because I'll spend the next 5 weeks traveling in Scandinavia :-) ------_=_NextPart_001_01C574A9.DCA949B1 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Ethan

 

>ORA-03237: Initial Extent of specified size cannot be = allocated in tablespace
>
>Running import from a 9.2.0.4 dump file into a 9.2.0.4 database with = a 8k block size. Keep getting
>this error because freelist groups is set to 10 in the import file. = If I take a copy of the
>statement and lower the FLG to 4 it works. It is going into a LMT = with a 64K extent size, it is
>trying to make a 128K object, however I thought it should just = ignore the storage on the import
>file (at least the extent size), how does FLG effect this?

The freelist group blocks have to = be allocated just after the segment header block in the *first* extent. = Since in your case the extents have only 8 blocks, you cannot specify 10 = freelists groups. You should either change the size of the extents or lower the = number of freelist groups.

 

HTH
Chris

 

PS: If I don’t reply to = further posts on this or others threads, it’s simple because I’ll spend = the next 5 weeks traveling in Scandinavia :-)

------_=_NextPart_001_01C574A9.DCA949B1-- -- http://www.freelists.org/webpage/oracle-l