It's DBA_TEMP_FILES. I'm the fastest typist in the whole wild west, but not the most accurate. May be I need a Chicago typewriter. -- Mladen Gogala A & E TV Network Ext. 1216 > -----Original Message----- > From: Gogala, Mladen [mailto:Mladen.Gogala@xxxxxxxx] > Sent: Tuesday, November 16, 2004 4:43 PM > To: 'JaehneRS@xxxxxxxxx'; 'Oracle-L (E-mail) > Subject: RE: Datafile info. > > > Did you try selecting from DBA_TEMPFILES as well? The > tablespace may even be -- //www.freelists.org/webpage/oracle-l