Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> locally managed tablespace question

locally managed tablespace question

From: Phillip <tienp_at_wholefoods.com>
Date: Tue, 26 Jun 2001 20:58:51 GMT
Message-ID: <3B38F775.E3735260@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 Tue Jun 26 2001 - 15:58:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US