System Tablespace allocation

  • From: "Goodson, Doris" <DGoodson@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 4 Jan 2006 12:28:01 -0800

I have a system tablespace that is 500M.  I am only using 350M of the
500M.  Each time that I run statistics, I am getting the 'ORA-1652:
unable to extend temp segment by 8091 in tablespace           SYSTEM'.
Any idea how to get rid of this error without expanding or adding
another datafile to the system tablespace?



Doris Goodson

County of Solano County


Other related posts: