RE: Datafile info.
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <davidsharples@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Nov 2004 09:40:12 -0500
I guess it depends on oracle version (and platform?):
SQL> select file_name from dba_data_files;
FILE_NAME
------------------------------------------------------------------------
----D:\ORANT\ORADATA\DDM\SYS1DDM.ORA
D:\ORANT\ORADATA\DDM\RBS1DDM.ORA
D:\ORANT\ORADATA\DDM\SYSAUX01.ORA
D:\ORANT\ORADATA\DDM\RMTL.ORA
D:\ORANT\ORADATA\DDM\RMTM.ORA
D:\ORANT\ORADATA\DDM\RMTS.ORA
6 rows selected.
Oracle10 on WinXP (and I know, actual file names are not all upper
case).
Igor Neyman, OCP DBA
ineyman@xxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Sharples
Sent: Wednesday, November 17, 2004 9:22 AM
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
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:
>
> select TABLESPACE_NAME, BYTES, BLOCKS from DBA_DATAFILES
> where FILE_NAME = UPPER('/oracle/dbs/BIG.dbf');
>
> Igor Neyman, OCP DBA
> ineyman@xxxxxxxxxxxxxx
>
>
>
>
> -----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.
>
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
