RE: Datafile info.

From: Leonard, George <GLeonard_at_wesbank.co.za>
Date: Thu, 18 Nov 2004 11:58:46 +0200
Message-ID: <1831A554E8800049B6B970790D2513C001C35DC4@fnbkrkmx01.fnb.co.za>

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_at_wesbank.co.za
=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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples Sent: 17 November 2004 16:22 PM
To: oracle-l_at_freelists.org
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_at_perceptron.com> 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_at_perceptron.com

>=20
>=20
>=20
>=20

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] 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
> --
> http://www.freelists.org/webpage/oracle-l

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://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                              ________________________________
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 18 2004 - 04:01:01 CST