Santosh Kumar wrote:The database convert work from 10.2 onward and no need this metalink note, the doc is clear engouh :
Firstly it says,
Oracle Server - Enterprise Edition - Version: 10.2.0.2
and then on forth point it says,
4) The Source and the target database version must be equal / greater than 10.2.0. version (So even 10.2.0.1 is also included)
Apart from this method, use of logical backup for migration seems more easy and trusted (Since we're doing from long back).Database convert, if it is working, is the easiest way to migrate a db accross plateform, no need to create a new db and so on. And if it is working fine even it is only not older than a 10g feature.
Objects with underlying objects (such as materialized views) or contained objects (such as partitioned tables) are not transportable unless all of the underlying or contained objects are in the tablespace set.This is one of the limitations of transportable tablespace, documented in the doc I linked earlier. There are other, and of course, the OP is invited to check the doc.