From oracle-l-bounce@freelists.org Wed Nov 17 08:12:10 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAHEC8v24138 for ; Wed, 17 Nov 2004 08:12:09 -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 iAHEC8i24129 for ; Wed, 17 Nov 2004 08:12:08 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F15B872C996; Wed, 17 Nov 2004 09:18: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 19152-52; Wed, 17 Nov 2004 09:18:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 244A772C35F; Wed, 17 Nov 2004 09:13:52 -0500 (EST) From: "Igor Neyman" To: , "''Oracle-L (E-mail)'" Subject: RE: Datafile info. Date: Wed, 17 Nov 2004 09:08:15 -0500 Message-ID: <002001c4ccae$e1f8eee0$2004a8c0@development.perceptron.com> MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit In-Reply-To: <2BF02E41764FE640B254C590B169C85C02614B91@MSWASHDCMB02.irm.state.gov> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-archive-position: 12340 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ineyman@perceptron.com Precedence: normal Reply-To: ineyman@perceptron.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES where FILE_NAME = UPPER('/oracle/dbs/BIG.dbf'); Igor Neyman, OCP DBA ineyman@perceptron.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jaehne, Richard S Sent: Tuesday, November 16, 2004 3:38 PM To: 'Oracle-L (E-mail) Subject: Datafile info. All,=20 I've got a large (4G.) datafile let's call him BIG.dbf on one of my = database servers that I'm not sure what's living in it. =20 I did run the following sql statement: SQL> select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES 2 where FILE_NAME =3D '/oracle/dbs/BIG.dbf'; no rows selected Does this mean that this is an empty file? I'm a little puzzled. Thanks,=20 Richard Jaehne -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l