Re: 9i Ques

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?

1. 900
2. 0
3. 10800
4. 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).