TEMP tablespace in local extents
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: TEMP tablespace in local extents

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Hi all,

    I have my TEMP tablespace created in locally extents, so I ran our of space the TEMP tablespace, what I did was to add another datafile with the intial extent =10m and autoextend with the max is 3000M. The additional file was created so when I look into the data files the auto extend was off.

    1. Can someone tell me what happened ???
    2. If I won't be able to shrink the TEMP tablesapce????

    Thanks

  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    dear sir
    which version of ORACLE are u using.

    If using 9i then no problems

    viraj
    ----------------
    9i OCA
    A Wise Man Knows How much he doesn't know !!!

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Can you post you script to add datafile. And also the view you are looking into.

    Sanjay

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Originally posted by ashley75
    2. If I won't be able to shrink the TEMP tablesapce????
    I don't think it's possible to shrink it.
    Create fresh temporary tablespace, set users to have it as their temporary tablespace, offline the old one, drop it, delete files.
    That's way I "shrink" the temporary LMT. I don't say it's the only or the best way but it works.
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot shrink temp tablespace in 9i

  6. #6
    Join Date
    Jan 2002
    Posts
    474
    ALTER TABLESPACE TEMP ADD TEMPFILE 'd:\oradata\test\temp_01.dbf' SIZE 10240K AUTOEXTEND ON NEXT 25600K MAXSIZE 3072000K
    /


    We have DBArtisan and I look into the TEMP tablespace and I saw the auto extend was off. It only add 10M to my TEMP.


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