1 2 Previous Next 16 Replies Latest reply: Mar 21, 2013 6:02 AM by psantosh RSS

    ORA-1652: unable to extend temp segment by 128 in tablespace STAGING_TEST

    aanto
      Hi,

      Oracle:11.2.0.3
      OS :Linux 5.8


      ORA-1652: unable to extend temp segment by 128 in tablespace STAGING_TEST
      ORA-1652: unable to extend temp segment by 8192 in tablespace STAGING_TEST
      ORA-12012: error on auto execute of job "STAGING_TEST"."PDM_MAIL_SCHEDULER"
      ORA-06550: line 1, column 786:


      we are getting the below error, we have a tablespace STAGING_TEST, it was only 75% full & TEMP is also almost free and "auto extent is on" on all datafiles.
      why we are getting this error when it is having space(TEMP & STAGING_TEST)....

      one more doubt.

      1.where we need to add datafile whether in STAGING_TEST or TEMP ?
      2.What is this msg exactly means....space problem is in TEMP or STAGING_TEST ?
      3.Even though auto extent is on and space is available in disk, why we are getting this error....


      Pls suggest...

      Thanks
      @ble
        1 2 Previous Next