Temporary datafile - truncate
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Temporary datafile - truncate

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all, I am using Oracle 8.1.6 on Solaris. If I want to free up some space on the server, can I truncate the data in my temporary datafile, If yes, then what are the other issues I need to take care of ?

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    You can't truncate from the temporary datafiles. Truncate can be issued against table data but the tables are not stored in temporary tablespace.

  3. #3
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    My temporary datafile is 3 GB in size. Is there no way I can shirnk that space??

  4. #4
    Join Date
    Aug 2001
    Posts
    267
    We have to think so many factors .

    !. check you have so many sorts against the database sql's or
    2. When created temp space you might have bigger initial extent /size..

    Second case is if you are not using 3Gb temp space just drop it and recreate it with less size making sure currently you don't have data on temp space ...
    Raghu

  5. #5
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    So raghu, you mean to say that taking the tablespace offline, dropping & recreating the datafile should work fine ? What are the other issues I need to take care of ?

    Shiva.

  6. #6
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    YOu can RESIZE datafiles smaller, but you can't RESIZE to a size SMALLER than the datafiles HighWatermark.
    OCP 8i, 9i DBA
    Brisbane Australia

  7. #7
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I believe you can resize the data files for ANY tablespace, provided you don't have data blocks beyond the new EOF (End of File) marker and what GRJOHNSON said about the HighWatermark

    -Ken

    [Edited by KenEwald on 03-11-2002 at 06:39 PM]

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