If this UNDO ts name matches the name in initSId.ora undo_tablespace=your_undo_ts_name then it should be all set. BTW, here is what I have from my 9i test db: SQL> select segment_name,owner from dba_rollback_segs; SEGMENT_NAME OWNER ------------------------------ ------ SYSTEM SYS _SYSSMU1$ PUBLIC _SYSSMU2$ PUBLIC _SYSSMU3$ PUBLIC _SYSSMU4$ PUBLIC _SYSSMU5$ PUBLIC _SYSSMU6$ PUBLIC _SYSSMU7$ PUBLIC _SYSSMU8$ PUBLIC _SYSSMU9$ PUBLIC _SYSSMU10$ PUBLIC 11 rows selected. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Aragon, Gabriel (GE Commercial Finance) Sent: Friday, August 06, 2004 11:48 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: RBS in SYSTEM Ts ok, I didn't see the complete scenary, there's an UNDO ts created, in = that case all the undo operations are redirected to this TS? If so then, = the rbs created on SYSTEM ts is just ignored? or is still a possible = issue and would be better to remove it? GAP -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Guang Mei Sent: Viernes, 06 de Agosto de 2004 10:37 a.m. To: oracle-l@xxxxxxxxxxxxx Subject: RE: RBS in SYSTEM Ts Gabriel: You are absolutely right. You can ask the DB owner to read some basic = oracle docs. Guang -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Aragon, Gabriel (GE Commercial Finance) Sent: Friday, August 06, 2004 11:30 AM To: oracle-l@xxxxxxxxxxxxx Subject: RBS in SYSTEM Ts Hello list, I just found in the DB that the only RBS created is using = =3D the SYSTEM ts, I want to suggest the DB owner to create another TS for = =3D RBS operations with 3 or 4 RBS, and not use the SYSTEM ts for these =3D operations, the reasons I give are that the performance can be affected = =3D because the rbs operations are accesing the same TS that the DD and also = =3D that the rbs operations can make this ts grow to a huge size, I think = =3D those are valid and enough reasons to do it. Am I missing something =3D else?=3D20 TIA Gabriel ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------