PSTEMP2 is the temporary tablespace. I just found my problem. My temporary tablespace has ran out of space on disk. Thanks for all your help. Doris -----Original Message----- From: Dennis Williams [mailto:oracledba.williams@xxxxxxxxx] Sent: Wednesday, January 04, 2006 12:35 PM To: Goodson, Doris Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: System Tablespace allocation Doris, > 'ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM'. For the username you are using to run statistics, what is defined as the TEMPORARY TABLESPACE? Dennis Williams -- //www.freelists.org/webpage/oracle-l