From oracle-l-bounce@freelists.org Fri Dec 10 12:13:46 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iBAIDkd09919 for ; Fri, 10 Dec 2004 12:13:46 -0600 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 iBAIDgm09902 for ; Fri, 10 Dec 2004 12:13:43 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B30C872C7E0; Fri, 10 Dec 2004 13:14:54 -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 26584-51; Fri, 10 Dec 2004 13:14:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8556772CCBD; Fri, 10 Dec 2004 13:14:49 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=rX1mH+1GQ+eo+L3IKkcdW/eZqwnlVZrnZrih06Sx1mbh3xgdr9vZwpH8AgZxZQJvHEW9Fn9KfqTy/80PR320Oy+I82c77lMruQMSJEFEONvrTnZTop5YO7yrL1f5lPJwJTcwOco5s4I+6oF8M/V64J4ueWfeFFUTTJDVowp6fdY= Message-ID: Date: Fri, 10 Dec 2004 11:12:26 -0700 From: Bryan Wells To: Oracle-L Subject: ORA-01114: IO error writing block to file 125 Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-archive-position: 13480 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bunjibry@gmail.com Precedence: normal Reply-To: bunjibry@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org All Im running 9.2.0.0 on MS 2000 Advanced Server when I get the previously mentioned error, allong with the following when attempting to create a materialized view. Here are the tablespace specs as well. up to last evening, this view was being created just fine. I have been looking at metalink et. al. site that stating datafile size greater than 4G, but am concerned about the validity since this has not happened prior to this. Im hoping someone can tell if Im just too green. At any rate, if anyone has had this issue and has a solution, hopfully not that the DB is completely HOSED. please respond. Il buy the virtual beers ============================================================ CREATE TABLESPACE "STAR_DATA_MV" NOLOGGING DATAFILE 'E:\ORACLE\ORADATA\GDWP\STAR_DATA_MV_01.DBF' SIZE 4096M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE 4096M, 'E:\ORACLE\ORADATA\GDWP\STAR_DATA_MV_02.DBF' SIZE 4096M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 4096M, UNIFORM SIZE 1024K SEGMENT SPACE MANAGEMENT MANUAL ============================================================ Dump file d:\oracle\admin\gdwp0\bdump\gdwp_dbw0_1884.trc Fri Dec 10 03:29:03 2004 ORACLE V9.2.0.1.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Instance name: gdwp Redo thread mounted by this instance: 1 Oracle process number: 3 Windows thread id: 1884, image: ORACLE.EXE *** 2004-12-10 03:29:03.000 *** SESSION ID:(2.1) 2004-12-10 03:29:03.000 KCF: write/open error block=0x1f245 online=1 file=121 E:\ORACLE\ORADATA\GDWP\STAR_DATA_MV_02.DBF error=27069 txt: 'OSD-04026: Invalid parameter passed. (OS 127557)' error 1242 detected in background process ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01114: IO error writing block to file 121 (block # 127557) ORA-01110: data file 121: 'E:\ORACLE\ORADATA\GDWP\STAR_DATA_MV_02.DBF' ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file OSD-04026: Invalid parameter passed. (OS 127557) ============================================================ -- Bryan S Wells - DBA Newbie bunjibry@gmail.com -- http://www.freelists.org/webpage/oracle-l