Re: undo tablespace and rollback segments in oracle9i
Your question is not very clear. Sorry. Can you please post results of following commands? Thanks. - Kirti SQL show parameter undo SQL select segment_name, tablespace_name from dba_rollback_segs; SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: undo tablespace and rollback segments in oracle9i
The scenario you describe is not consistent with manual undo. Was the database created/started with automatic undo and you have switched to manual? [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: undo tablespace and rollback segments in oracle9i
hi , please look attached file ; -Original Message- Sent: Wednesday, July 30, 2003 3:52 PM To: [EMAIL PROTECTED] Cc: Bahar, Arslan Your question is not very clear. Sorry. Can you please post results of following commands? Thanks. - Kirti SQL show parameter undo SQL select segment_name, tablespace_name from dba_rollback_segs; SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com encoded content removed -- binaries not allowed by ListGuru
RE: undo tablespace and rollback segments in oracle9i
yes . What should i do -Original Message- Sent: Wednesday, July 30, 2003 5:30 PM To: Multiple recipients of list ORACLE-L The scenario you describe is not consistent with manual undo. Was the database created/started with automatic undo and you have switched to manual? [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: undo tablespace and rollback segments in oracle9i
If you are now running in manual undo mode and have created rollback segments, you can remove the undo segments. Verify that the segments are offline and you are not using them. Then drop the undo tablespace. This is the only way to get rid of them. [EMAIL PROTECTED] wrote: yes . What should i do -Original Message- Sent: Wednesday, July 30, 2003 5:30 PM To: Multiple recipients of list ORACLE-L The scenario you describe is not consistent with manual undo. Was the database created/started with automatic undo and you have switched to manual? [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: undo tablespace and rollback segments in oracle9i
Your attachment was removed by the list server. However, your direct e-mail to me had the following: SQL show parameter undo ; NAME TYPEVALUE --- -- undo_management string MANUAL undo_retention integer 900 undo_suppress_errors boolean FALSE undo_tablespace string rbs SQL SQL select segment_name, tablespace_name from dba_rollback_segs; SEGMENT_NAME TABLESPACE_NAME -- -- SYSTEM SYSTEM _SYSSMU1$ RBS _SYSSMU2$ RBS _SYSSMU3$ RBS _SYSSMU4$ RBS _SYSSMU5$ RBS _SYSSMU6$ RBS _SYSSMU7$ RBS _SYSSMU8$ RBS _SYSSMU9$ RBS _SYSSMU10$ RBS SEGMENT_NAME TABLESPACE_NAME -- -- RBS01 RBS RBS02 RBS RBS03 RBS RBS04 RBS RBS05 RBS RBS06 RBS 17 rows selected. SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; USN NAME STATUS -- -- --- 0 SYSTEM ONLINE 11 RBS01 ONLINE 12 RBS02 ONLINE 13 RBS03 ONLINE 14 RBS04 ONLINE 15 RBS05 ONLINE 16 RBS06 ONLINE 7 rows selected. --- So, it is clear that RBSnn were created in an undo tablespace titled RBS. To remove system managed undo segments (_SYSSMUn$) one must drop the undo tablespace itself. But, in your case, you will first have to: 1. Create a new, normal tablespace, say, rollback_ts, to hold new rollback segments (do not create it using create undo tablespace ) 2. Create required rollback segments (rbs07, rbs08 etc) in rollback_ts. 3. Bring them all online. 4. Offline RBS01 to RBS06 and drop them. 5. Drop tablespace RBS. Modify init.ora parameter as required. Hope this helps. - Kirti --- [EMAIL PROTECTED] wrote: hi , please look attached file ; -Original Message- Sent: Wednesday, July 30, 2003 3:52 PM To: [EMAIL PROTECTED] Cc: Bahar, Arslan Your question is not very clear. Sorry. Can you please post results of following commands? Thanks. - Kirti SQL show parameter undo SQL select segment_name, tablespace_name from dba_rollback_segs; SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling