Datafiles names are actually stored in the exact format it was specified in (case/format of file on file system), very important on unix environments where filename can be exactly the same except for the Case. If I am not wrong on NT it actually uppercases the file where on unix it is left as specified. George =20________________________________________________ George Leonard Oracle Database Administrator New Dawn Technologies @ Wesbank E-mail:gleonard@xxxxxxxxxxxxx =20 You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! =20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Sharples Sent: 17 November 2004 16:22 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Datafile info. data files are not stored in up case in the data dictionaey SQL> select file_name from dba_data_files =20 2 / FILE_NAME ------------------------------------------------------------------------ -------- /u02/oradata/system01.dbf So your query would return nothing (something you could of checked) On Wed, 17 Nov 2004 09:08:15 -0500, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote: >=20 > select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES > where FILE_NAME =3D UPPER('/oracle/dbs/BIG.dbf'); >=20 > Igor Neyman, OCP DBA > ineyman@xxxxxxxxxxxxxx >=20 >=20 >=20 >=20 > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jaehne, Richard S > Sent: Tuesday, November 16, 2004 3:38 PM > To: 'Oracle-L (E-mail) > Subject: Datafile info. >=20 > All,=3D20 >=20 > I've got a large (4G.) datafile let's call him BIG.dbf on one of my =3D= > database servers that I'm not sure what's living in it. =3D20 >=20 > I did run the following sql statement: >=20 > SQL> select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES > 2 where FILE_NAME =3D3D '/oracle/dbs/BIG.dbf'; >=20 > no rows selected >=20 > Does this mean that this is an empty file? I'm a little puzzled. >=20 > Thanks,=3D20 >=20 > Richard Jaehne > -- > //www.freelists.org/webpage/oracle-l >=20 > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l _________________________________________________________________________= __________________________ The views expressed in this email are, unless otherwise stated, those of = the author and not those of the FirstRand Banking Group an Authorised Financial Service Provider o= r its management. The information in this e-mail is confidential and is intended solely for= =20the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribut= ion or any action taken or=20 omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrit= y of information and data=20 transmitted electronically and to preserve the confidentiality thereof, n= o liability or=20 responsibility whatsoever is accepted if information or data is, for what= ever reason, corrupted=20 or does not reach its intended destination. =20 ________________________________ -- //www.freelists.org/webpage/oracle-l