Re: locally managed tablespace question

Phillip wrote:
> 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

temporary tablespaces don't have "datafiles", they have "tempfiles". Do a select from dba_temp_files and you'll find your files.

        E. Received on Tue Jun 26 2001 - 16:38:51 CDT