> -----Original Message-----
> From: Connie Milliken [mailto:[EMAIL PROTECTED]]
>
> 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.
