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

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-01130

ORA-01130

From: <genegurevich_at_discoverfinancial.com>
Date: Wed, 6 Dec 2006 17:33:56 -0600
Message-ID: <OFD1E30F42.82683280-ON8625723C.00811190-8625723C.00817259@discoverfinancial.com>


Hi all:

Here is my situation. I have a 10.2.0.1 database (DB01) where compatible parameter is set to 10.2.0. I have a cold backup created last night and I would like to restore it on another server where I have 10.2.0.1 database (DB02) ,
but with the compatible parameter set to 10.0.0. I am getting the error:

ORA-01130: database file version 10.2.0.0.0 incompatible with ORACLE version
10.0.0.0.0
ORA-01110: data file 1: '/opt/oracle/data/pcfr01/data10/cfr_system01.dbf'

Does that mean that I have to change the compatible parameter on my DB02 database to match the one on
DB01 (e.g - 10.2.0) in order to do the restore or is there a way to accomplish the restore the way I want?

thank you

Gene Gurevich

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 06 2006 - 17:33:56 CST

Original text of this message

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