/2003 04:34 PM
Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]> cc:
Subject: RE: ORA-1652: unable to
extend temp segment by 8091 in tablespace
tablespace_name = 'SYSTEM';
If you find other owners objects in SYSTEM, particularly SAPR3 objects, they
should be moved to the proper tablespace.
HTH
jared
raju pa <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/15/2003 04:34 PM
Please respond to ORACLE-L
PSAPUSER1D PSAPTEMPOPS$ORAQA2 SYSTEM PSAPTEMPOPS$QA2ADM SYSTEM PSAPTEMP
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 4:28 PMTo: [EMAIL PROTECTED]Cc: Roger XuSubject: Re: ORA-1652: unable to extend temp
t;[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject: RE: ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM
USERNAME DEFAULT_TABLESP TEMPORARY_TABLE
--- --- ---
SAPR3 PSAPUSER1D P
PROTECTED]Sent: Friday, August 15, 2003 4:28
PMTo: [EMAIL PROTECTED]Cc: Roger
XuSubject: Re: ORA-1652: unable to extend temp segment by 8091 in
tablespace SYSTEMImportance: HighWhat does this query return? select username, default_tablespace,
temporary_tablespace from
dba_users
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: