how to chk which tablespaces has been used as TEMP in oracle 7.3.X ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to chk which tablespaces has been used as TEMP in oracle 7.3.X ??

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    how to chk which tablespaces has been used as TEMP in oracle 7.3.X ??

    hi guys,

    Will appreciate if anyone could point to me how can I check which tablespace has been used for temporary TS in Oracle 7.3.X ?? As I know in oracle8i there's this DBA_TEMP_FILES but I cannot find this in oracle 7.3.X ??

    anyone can enlighten?

    thank-u

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: how to chk which tablespaces has been used as TEMP in oracle 7.3.X ??

    Originally posted by ngwh
    hi guys,

    Will appreciate if anyone could point to me how can I check which tablespace has been used for temporary TS in Oracle 7.3.X ?? As I know in oracle8i there's this DBA_TEMP_FILES but I cannot find this in oracle 7.3.X ??

    anyone can enlighten?

    thank-u
    There are no tempfiles prior to version 8i. Neither there is any default temporary tablespace for database (not user) prior to version 9i.

    To check your temporary tablespace and datafiles in 7.X check DBA_TABLESPACES and DBA_DATA_FILES.
    If you want to check default tablespace for each user, check DBA_USERS.
    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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