Thanks all. The replies have been really helpful.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 6:49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1652: unable to extend temp segment by 8091 in
Hello,
While user OPS$ORAQA2 running:
ANALYZE TABLE SAPR3.BSIS COMPUTE STATISTICS FOR TABLE FOR ALL INDEXED COLUMNS SIZE
1 FOR ALL INDEXES
I had the following error:
SQL error -1652 at location stats_tab_collect-4
ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM
A
What does this query return?
select username, default_tablespace, temporary_tablespace
from dba_users
where username like 'OPS$%' or username = 'SAPR3'
Jared
Roger Xu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/15/2003 12:34 PM
Please respond to ORACLE-L
To:Multiple
USERNAME DEFAULT_TABLESP
TEMPORARY_TABLE--- ---
---SAPR3
PSAPUSER1D
PSAPTEMPOPS$ORAQA2
SYSTEM
PSAPTEMPOPS$QA2ADM
SYSTEM
PSAPTEMP
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 4:28
You need to change the default tablespace for those OPS$ users
alter user OPS$ORAQA2 default tablespace PSAPUSER1D;
and
alter user OPS$QA2ADM default tablespace PSAPUSER1D;
should do it.
The only user that should have the SYSTEM tablespace as a
default is the SYS user. All others should be
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 userobjects. Move them away. I do not know if moving system objects out of 'system'