From oracle-l-bounce@freelists.org Thu Nov 18 07:30:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAIDULw02678 for ; Thu, 18 Nov 2004 07:30:21 -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 iAIDULi02672 for ; Thu, 18 Nov 2004 07:30:21 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AF79272DFC5; Thu, 18 Nov 2004 08:36:39 -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 16668-98; Thu, 18 Nov 2004 08:36:39 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CF51972D42A; Thu, 18 Nov 2004 08:31:49 -0500 (EST) Message-ID: X-Sybari-Trust: 6bf4ed83 1e849ab0 6a24f00d 0000013d From: "Mercadante, Thomas F" To: "'JaehneRS@state.gov'" , "'Oracle-L (E-mail)" Subject: RE: Datafile info. Date: Thu, 18 Nov 2004 08:25:34 -0500 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 12396 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: thomas.mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Richard, The problem could simply be spelling or upper/lower case issues. Try running the following and see what you get: select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES / Tom Mercadante Oracle Certified Professional -----Original Message----- From: Jaehne, Richard S [mailto:JaehneRS@state.gov] 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