Re: Oracle 8.1 and 8.0.5 compatibility

2002-07-02 Thread Bunyamin Karadeniz

I had experienced a similar thing too. But I had opened the database with
the compatible parameter database needed to startup..

Try to change the compatible parameter in my opinion to open the database.
,

Bunyamin



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 02, 2002 12:03 PM


> I had a problem.
> Trying to drop a column from a Oracle 8i Table (personal edition on a
> w2kPro) i got the following message (or similar) " you can't drop a table
> with 8.0.5 compatibility, you need at least 8.1.0. !
> Ok, i changed compatibiliy parameter from 8.0.5 to 8.1.0 (using dba
studio)
> and all seems to be right.
> The first time i've restarted the dba machine Oracle did not come up any
> more (the db was mounted but not opened).
> Other way i cant go back to 8.0.5 compatibility because the dropped column
!
> what can i do ?
> Any help will be appreciated.
> Marcello
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Marcello  Savino
>   INET: [EMAIL PROTECTED]
>
> 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: [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.com
-- 
Author: Bunyamin Karadeniz
  INET: [EMAIL PROTECTED]

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



Oracle 8.1 and 8.0.5 compatibility

2002-07-02 Thread Marcello Savino

I had a problem.
Trying to drop a column from a Oracle 8i Table (personal edition on a
w2kPro) i got the following message (or similar) " you can't drop a table
with 8.0.5 compatibility, you need at least 8.1.0. !
Ok, i changed compatibiliy parameter from 8.0.5 to 8.1.0 (using dba studio)
and all seems to be right.
The first time i've restarted the dba machine Oracle did not come up any
more (the db was mounted but not opened).
Other way i cant go back to 8.0.5 compatibility because the dropped column !
what can i do ?
Any help will be appreciated.
Marcello
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marcello  Savino
  INET: [EMAIL PROTECTED]

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