Database Administration (MOSC)

MOSC Banner

Transportable tablespaces - Source is 10g , Target is 11g

edited Jan 17, 2014 11:00AM in Database Administration (MOSC) 6 commentsAnswered
Hi

we have 2 databases 10g (Windows X65)  and 11g (Linux X64)

We are trying to perform transportable tablespace migration from 10g database to 11g database

The compatible parameter is "10.2.0.2.0" on 10g database and "11.2.0.4.0" on the 11g database and we know that we need set the compatible value to 11g database (Target)  to be exactly what we have on the 10g database (Source)

Before we start transporting the table spaces we set the compatible to 10.2.0.2.0 on the 11g database and then started up the database but we got the following error

ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version
10.2.0.2.0
ORA-00202: control file: '/u02/oracle/oradata/db11g/control01.ctl'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center