From oracle-l-bounce@freelists.org Tue Sep 14 12:04:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8EH46r13696 for ; Tue, 14 Sep 2004 12:04:06 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i8EH46I13691 for ; Tue, 14 Sep 2004 12:04:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2227C72D235; Tue, 14 Sep 2004 12:10:04 -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 14683-53; Tue, 14 Sep 2004 12:10:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8D1B372D219; Tue, 14 Sep 2004 12:10:03 -0500 (EST) From: "Darrell Landrum" To: , Subject: RE: problem with creating non default blocksize tablespace Date: Tue, 14 Sep 2004 12:08:32 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcSaeKK49jIjzvhIRqOts5j/xvQRJAABC6MAAAAYdAA= Message-Id: <20040914170836.5AB6C72C09B@turing.freelists.org> X-archive-position: 9461 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: darrell@landrum.com Precedence: normal Reply-To: darrell@landrum.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I was trying to check the docs, but the 9i ones seem to be unavailable at otn right now. However, I'd look toward reducing the size of datafile /dev/rvd_bptrnext8 from the almost 20 GB that is specified. >From that error message, it appears there would be a file size limit of 7.99 GB. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Fuad Arshad Sent: Tuesday, September 14, 2004 11:34 AM To: oracle-l@freelists.org Subject: problem with creating non default blocksize tablespace I've already set the db_2k_cache_size is there a limitation for setting this up. what do i need to check . what am i doing wrong. couldnt find anything on metalink nor the docs. SQL> CREATE TABLESPACE D_PATLOB DATAFILE '/dev/rvd_bptrnext8' SIZE 20010M AUTOEXTEND OFF, '/dev/rvd_txnrsp3' SIZE 9000M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL UNIFORM SIZE 200M BLOCKSIZE 2K; 2 3 4 5 6 7 8 CREATE TABLESPACE D_PATLOB DATAFILE * ERROR at line 1: ORA-01144: File size (10245120 blocks) exceeds maximum of 4194303 blocks -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l