This discussion is archived
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 Newbie
Currently Being Moderated
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

Legend

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