RE: compatible in 9iRel2

2003-01-13 Thread DENNIS WILLIAMS
David - No. This just ensures you don't use any "9i" only features. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 1:22 PM To: Multiple recipients of list ORACLE-L I was curious about this parameter I have an appli

RE: compatible in 9iRel2

2003-01-13 Thread david hill
, January 13, 2003 1:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: compatible in 9iRel2   We are running 9.2.0.1., do you think that could be the reason.   the .1=component specifiec Release Number?  Was your 9i  9.2.0.0.0? David Ehresmann. -Original Message- From: John

RE: compatible in 9iRel2

2003-01-13 Thread John Shaw
:[EMAIL PROTECTED]]Sent: Monday, January 13, 2003 11:41 AMTo: Multiple recipients of list ORACLE-LSubject: RE: compatible in 9iRel2 I had a 9.2/solaris database that I could set compatible 8.1.7 on - but since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either -

RE: compatible in 9iRel2

2003-01-13 Thread Ehresmann, David
list ORACLE-LSubject: RE: compatible in 9iRel2 I had a 9.2/solaris database that I could set compatible 8.1.7 on - but since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either - never really needed it so I haven't bothered with metalink/tar. >>> [

RE: compatible in 9iRel2

2003-01-13 Thread Ehresmann, David
Were you using any of the new tablespace features or using dictionary managed tablespaces? David Ehresmann -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Monday, January 13, 2003 11:41 AMTo: Multiple recipients of list ORACLE-LSubject: RE: compatible in

RE: compatible in 9iRel2

2003-01-13 Thread Jamadagni, Rajendra
Title: RE: compatible in 9iRel2 Curious minds want to know what bugs you are trying to fix ?? Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn&#

Re: compatible in 9iRel2

2003-01-13 Thread Jared Still
You need to create the database with compatible set to 8.1.7.0. You can't create a database at one version and then lower the compatible level without downgrading or recreating. Jared On Monday 13 January 2003 09:16, Ehresmann, David wrote: > I am trying to apply a "fix" for some developers he

RE: compatible in 9iRel2

2003-01-13 Thread John Shaw
I had a 9.2/solaris database that I could set compatible 8.1.7 on - but since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either - never really needed it so I haven't bothered with metalink/tar. >>> [EMAIL PROTECTED] 01/13/03 11:16AM >>>I am trying to apply a "fix" for som

RE: compatible in 9iRel2

2003-01-13 Thread Ehresmann, David
I am trying to apply a "fix" for some developers here. They used this fix in 8 and 8i by changing the compatible parameter and running their sql script. I just want to be able to tell them that they need to fix their application now that we are using 9iRel2. I tried this morning and got the ORA-

RE: compatible in 9iRel2

2003-01-13 Thread DENNIS WILLIAMS
David - Try COMPATIBLE=8.1.0 See the following link (you may have to patch it back together) http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96530/migcompa.htm#1 009871 Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 200

RE: compatible in 9iRel2

2003-01-13 Thread DENNIS WILLIAMS
David - What are you trying to accomplish? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 8:44 AM To: Multiple recipients of list ORACLE-L List, I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Sola