Oracle-L: Re: COMPATIBLE Parameter in INIT.ORA

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 07 Apr 2003 09:59:18 -0800
Message-ID: <F001.0057BF0D.20030407095918@fatcity.com>

Just ensure clean shutdown(normal or immediate or abort , start, shutdown immediate) , then change this parameter and restart database.

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Mon, 07 Apr 2003 07:08:39 -0800

Hi All,

I've been reading up in Metalink about the COMPATIBLE parameter in the INIT.ORA. The article that I was reading was related to an Oracle 7 database and warned of the dangers of changing the COMPATIBLE value.

Does anybody know if this is still the case with Oracle 8?

I've recently inherited a database upgrade and noticed in the INIT.ORA that the COMPATIBLE parameter was not updated so I want to change it but would like to know what to look out for.

Many Thanks,

N.
<< winmail.dat >>

Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: M Rafiq
INET: rafiq9857_at_hotmail.com

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: ListGuru_at_fatcity.com (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). Received on Mon Apr 07 2003 - 12:59:18 CDT