-
UNDOTBS1 vs ROLLBACK SEGS
To all The 9i Gurus
New to 9i. just need a clarification on a point. Created 9i database and imported all my 8i data into it.
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
QUESTION
RBS is replaced by UNDOTBS1. Do i need to create another rollback segments tablespace?
If I do could you say why
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
-
-
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
Re: UNDOTBS1 vs ROLLBACK SEGS
Originally posted by Ablakios
QUESTION
RBS is replaced by UNDOTBS1. Do i need to create another rollback segments tablespace?
If I do could you say why
RBS TS is *not* replaced with UNDO TS. You can still create a RBS TS if you want.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Re: Re: UNDOTBS1 vs ROLLBACK SEGS
Originally posted by julian
RBS TS is *not* replaced with UNDO TS. You can still create a RBS TS if you want.
[Deep breath, "no stupid questions", sticks out head . . . ] Why might I want to?
-
Re: Re: Re: UNDOTBS1 vs ROLLBACK SEGS
Originally posted by DaPi
[Deep breath, "no stupid questions", sticks out head . . . ] Why might I want to?
Beats me. You might be really devoted to the concept :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
[relieved sigh . . . ] For a moment I thought I'd "lost it".
-
Originally posted by DaPi
[relieved sigh . . . ] For a moment I thought I'd "lost it".
4.5 version of SAP does not support UNDO_TABLESPACES, you must use RBSs if your database is 9i. It doesn't support pga_aggregate_target either.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
By setting undo_suppress_errors = true, oracle ignores the specific RBS setting by the application. This is a good parameter, when many 3rd party applications do not allow to change their code.
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|