ORA-1652: unable to extend temp segment by 32 in tablespace TEMP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-1652: unable to extend temp segment by 32 in tablespace TEMP

  1. #1
    Join Date
    Oct 2003
    Location
    manila, philipppines
    Posts
    6

    Lightbulb ORA-1652: unable to extend temp segment by 32 in tablespace TEMP

    I am getting the following message through Alert.log

    ORA-1652: unable to extend temp segment by 32 in tablespace TEMP

    How to fix this bugg?


    TIA
    Cheers!
    SivaRam

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    ummm extend the tablespace?

    alter database datafile 'xxx' resize xxxM;

    or the tempfile if its s true temporary tablespace

  3. #3
    Join Date
    Oct 2003
    Location
    manila, philipppines
    Posts
    6
    more information:

    1. Temp is not a Dictionary Managed Tablesapce
    2. with Uniform Allocation
    3. Extent management is "Locally"
    4. Current size is 4 Gb

    with the above points, how big that we can make this temp tablespace? If we make this around 10 G, are there any dependancy parameters? How to find out the what are the programs which consumes this temp tablespace memory?
    Cheers!
    SivaRam

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    You can make it as big as you want (or need)

    take a look at this to see who is using it

    http://www.jlcomp.demon.co.uk/faq/sort_user.html

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