This discussion is archived
7 Replies Latest reply: Jan 4, 2013 2:05 AM by 899401 RSS

ora1652

899401 Newbie
Currently Being Moderated
Hi,
i am getting below mentioend error in db

ora1652 unable to increase temp segment by 128 in tablespace temp
how to increase tablespace.please help with command

thanks
  • 1. Re: ora1652
    CKPT Guru
    Currently Being Moderated
    896398 wrote:
    Hi,
    i am getting below mentioend error in db

    ora1652 unable to increase temp segment by 128 in tablespace temp
    how to increase tablespace.please help with command

    thanks
    What is database version?
    refer documented link http://docs.oracle.com/cd/B19306_01/server.102/b14231/dfiles.htm
  • 2. Re: ora1652
    899401 Newbie
    Currently Being Moderated
    orar111g
  • 3. Re: ora1652
    Chanchal Wankhade Journeyer
    Currently Being Moderated
    Hi,

    look at the disk space first. if there is enought dist space then try to create new temp tablespace or add a temp file to exsiting temp tablespace.
    Remember all this can be created by Only the user who have DBA privileges.

    to create temp tablespace
    CREATE temporary TABLESPACE DT_TEMP
    tempfile 'path/filename.dbf' SIZE 320M
    to add temp file
    ALTER TABLESPACE lmtemp
       ADD TEMPFILE 'path/filename.dbf' SIZE 18M AUTOEXTEND ON;
    Size can be specify according to requirement.

    Edited by: Chanchal Wankhade on Jan 3, 2013 3:35 AM
  • 4. Re: ora1652
    967679 Newbie
    Currently Being Moderated
    Check the current temp size from :
    sql>select file_name,tablespace_name,bytes/(1024*1024*1024) from dba_temp_files
    If size is higher than expected, then you can try shrink the temp file space and can do the transaction again.

    To Shrink temp tablesapce, fire following:
    sql>alter tablespace temp shrink space
    check again the size. If tablespace shrinked enough to carry out your transaction, then proceed.
    If still get the same error, you can create additional temp tablespace file and add them to existing temp tablespace.
  • 5. Re: ora1652
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Refer to
    OERR: ORA 1652 unable to extend temp segment by %s in tablespace %s [ID 19047.1]
    Troubleshooting ORA-1652 Errors in RAC [ID 280578.1]
    ORA-1652 Error Troubleshooting [ID 793380.1]
  • 6. Re: ora1652
    Rob_J Journeyer
    Currently Being Moderated
    Hi,

    There are some notes on how to [url http://www.ora00600.com/scripts/databasemonitoring/temp.html]monitor TEMP space usage here, too, if you want to check how much is being used.

    Rob
  • 7. Re: ora1652
    899401 Newbie
    Currently Being Moderated
    thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points