Temp tablespace datafiles in D. Dictionary
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Temp tablespace datafiles in D. Dictionary

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    Temp tablespace datafiles in D. Dictionary

    This query DOES NOT show the TEMP tablespace!
    select a.tablespace_name, file_name, b.bytes, a.status
    from dba_tablespaces a, dba_data_files b
    where a.tablespace_name = b.tablespace_name

    This query DOES show the TEMP tablespace but still not the datafile (outer join with dba_data_files)!
    select a.tablespace_name, file_name, b.bytes, a.status
    from dba_tablespaces a, dba_data_files b
    where a.tablespace_name = b.tablespace_name (+)

    I also tried joins with v$sort_segment, v$datafile and Oracle still refuses to show the datafile but does show the tablespace WHY?

    I thought there might be some thing wrong with TEMP with the dB/Instance but I ran this for 4 different instances/dB.

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    I guess you are using LMT. Use dba_temp_files view.
    -nagarjuna

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width