RE: TEMP Tablespace

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 25 Sep 2001 10:54:34 -0700
Message-ID: <F001.00398207.20010925102023@fatcity.com>

> -----Original Message-----
> From: Connie Milliken [mailto:cemail_at_sprintmail.com]
>
> TEMP tablespace is not listed when I query dba_segments. However, it
> does show up in OEM and
> through OEM it does appear to be online. Yesterday, I
> briefly took the
> TEMP tablespace offline and then back online again to make sure it was
> completely cleared out (did not appear to be any active
> sessions in the
> database at the time). Have also bounced the database. Any ideas on
> why it still would not be showing up when querying dba_segments?

Is this a temporary tablespace that's locally managed with a temporary file? i.e. are the datafiles for that tablespace shown in dba_temp_files instead of dba_data_files? In that case, I don't think you'll see anything in the dba_segments view, but you would have to look at views like v$temp_space_header and v$temp_extent_map. Received on Tue Sep 25 2001 - 12:54:34 CDT