Re: locally managed tablespace question

Just a wild stab in the dark... but if you have created locally managed temporary tablespaces, I'll bet you created them with a 'create temporary tablespace blah TEMPFILE '/bing/bong/blah.dbf' etc etc etc'

Hence the thing is known to Oracle as a TEMPFILE, not a data file, and if memory serves, there's a special view for them (and I'm guessing wildly that it is dba_temp_files, just as the more conventional view is dba_data_files).

Your missing files will be in the _temp_files view, I am betting.

Regards
HJR "Phillip" <tienp_at_wholefoods.com> wrote in message news:3B38F775.E3735260_at_wholefoods.com...
> Fellow DBAs,
>
> why is it that when I do a query on a temporary tablespace (TEMP) which
> is managed locally for the datafiles I get 0 rows returned, but when I
> run the same query on another locally managed tablespace, the datafiles
> return?
>
> select file_name from dba_data_files where tablespace_name='TEMP';
> 0 rows returned
>
> select file_name from dba_data_files where tablespace_name='TB1';
> /oracle/ora1/oradata/tb1.dbf
>
> please copy tienp_at_wholefoods.com on your responses. Thanks.
>
> --
> Phillip
>
Received on Wed Jun 27 2001 - 04:41:49 CDT