RE: ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM

2003-08-15 Thread raju pa
Even if the default tablespace for user is other than 'SYSTEM' question is :   Where does the data from anlyze go? To some catalog table? What you can do is :   1) Check if 'SYSTEM' has any other user non-system/sys user objects. Move them away. I do not know if moving system objects out of 'system

RE: ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM

2003-08-15 Thread Roger Xu
USERNAME    DEFAULT_TABLESP TEMPORARY_TABLE--- --- ---SAPR3   PSAPUSER1D  PSAPTEMPOPS$ORAQA2  SYSTEM  PSAPTEMPOPS$QA2ADM  SYSTEM  PSAPTEMP   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL