7 Replies Latest reply: Jan 4, 2013 4:05 AM by 899401 RSS

    ora1652

    899401
      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
          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
            orar111g
            • 3. Re: ora1652
              Chanchal Wankhade
              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
                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
                  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
                    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
                      thanks