Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> locally managed tablespace question
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.
-- PhillipReceived on Tue Jun 26 2001 - 15:58:51 CDT