1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-01652 unable to extend temp segment by 16 in tablespace TEMP

Discussion in 'Server Administration and Options' started by aayan_110, Feb 17, 2011.

  1. aayan_110

    aayan_110 Active Member

    Messages:
    35
    Likes Received:
    1
    Trophy Points:
    90
    My temp table space is always showing 100% full,

    And now i am getting this error

    i closed the discoverer report restarted the server but sill having this error

    ORA-01652 unable to extend temp segment by 16 in tablespace TEMP

    How I can fixed this error?

    Thanks of your help.
    Regards
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    This is normal.

    But since you get this ORA-01652 error, u have to add one or more data file to you TEMP tablespace.

    ALTER TABLESPACE TEM ADD DATAFILE <<datafilepath>> size XXXm;


     
  3. aayan_110

    aayan_110 Active Member

    Messages:
    35
    Likes Received:
    1
    Trophy Points:
    90
    Dear Mr. Raj Thanks for the reply

    But i already added one gb data file still its showing me the same errror
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO