Temp files !! - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Temp files !!

  1. #11
    Join Date
    Jul 2003
    Posts
    323
    Actually it's created as a DMT so I guess it does not show up in dba_temp_files & v$tempfile in

    SQL> select * from v$version;

    BANNER
    ----------------------------------------------------------------
    Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
    PL/SQL Release 9.2.0.6.0 - Production
    CORE 9.2.0.6.0 Production
    TNS for Solaris: Version 9.2.0.6.0 - Production
    NLSRTL Version 9.2.0.6.0 - Production

    SQL> exec print_table('SELECT * FROM DBA_TABLESPACES WHERE TABLESPACE_NAME=''TEMP''');

    TABLESPACE_NAME : TEMP
    BLOCK_SIZE : 16384
    INITIAL_EXTENT : 524288
    NEXT_EXTENT : 2097152
    MIN_EXTENTS : 1
    MAX_EXTENTS :
    PCT_INCREASE : 0
    MIN_EXTLEN : 2097152
    STATUS : ONLINE
    CONTENTS : TEMPORARY
    LOGGING : LOGGING
    FORCE_LOGGING : NO
    EXTENT_MANAGEMENT : DICTIONARY
    ALLOCATION_TYPE : USER
    PLUGGED_IN : NO
    SEGMENT_SPACE_MANAGEMENT : MANUAL
    DEF_TAB_COMPRESSION : DISABLED
    -----------------


  2. #12
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by Mr.Hanky
    I'm guessing it is not LMT.

    Genius!
    I remember when this place was cool.

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