Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle 8.1 and 8.0.5 compatibility

Oracle 8.1 and 8.0.5 compatibility

From: Marcello Savino <marcello.savino_at_siaspa.it>
Date: Tue, 02 Jul 2002 01:03:20 -0800
Message-ID: <F001.0048D990.20020702010320@fatcity.com>


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: marcello.savino_at_siaspa.it

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). Received on Tue Jul 02 2002 - 04:03:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US