I believe that when you create a database with the GUI it sets undo_retention to 10800. Perhaps if you set it to blank then 9.2 will default to 900.
"Senthil Kumar
D" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<senthilkumard cc:
@summitworks.com Subject: 9i Ques
>
Sent by:
ml-errors
06/19/2003 12:34
PM
Please respond
to ORACLE-L
Hi Group,
What is the default value of Undo_retention?
a. 900
b. 0
c. 10800
d. None of the above
I have selected option a. The answer given by the system is c.
Which one is right. I have checked out with oracle doc's. It says 900. But
db (which has default parameters) says 10800.!!!!!!!!!
Any answers??
TIA
Senthil
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Senthil Kumar D
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: Thomas Day
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).
