Re: compatible parameter in init.ora

Dear Nico

My experiance should give U lot of insight into this problem.

One day in hurry I created 2 databases on Solaris , Oracle 7.3.2.

I wanted to add tablespaces, it flatly refused and says Your compatibility is of 0.0.0.0 I cann't write in the log as it is created with 0.0.0.0 compatibility.

I didn't know if I should cry or laugh !

I rushed to my init.ora

Yes, compatibility=7.3.2 but commented

Simply copying something , not going through all parameters costed me about half an hour more for deleting old one and for creating new dbs

If some one knows how to make 0.0.0.0. compatibility to 7 or 8 etc pl.. let me know

bye

Rao

--

On Mon, 25 Sep 2000 03:15:24  
 VERITE Nicolas BRX/FCR wrote:


>Hi all ! (once again)

>

>I wanted to resize a datafile on 7.3.2.3.0 on HP-UX 10.20,

>but the engine "answered" me the compatible parameter

>in initSID.ora was no set correctly...

>This parameter is not set in this BD.

>

>What is the impact of setting this parameter to a version or another ?

>(except I will be able to resize a datafile after next startup...)

>

>Thanx for your help.

>Nico

>

>Nicolas VERITE - DBA Oracle

>Univers Informatique - www.universinformatique.fr

>Fixe: 01 42 21 77 80 - Mobile: 06 62 70 77 48

>

>-- 

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

>-- 

>Author: VERITE Nicolas BRX/FCR

>  INET: nicolas.verite_at_francetelecom.fr

>

>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

>San Diego, California        -- Public Internet access / Mailing Lists

>--------------------------------------------------------------------

>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).

>



Get your FREE Email and Voicemail at Lycos Communications at