Oracle 10.2.0.4 to 11g R2
has anyone migrated a 10.2.0.4 32bit Windows to a new server running windows 64 bit with Oracle 11g R2?
I have cloned my 10g DB then cloned it into my 11g environment on the new server. I then recreated the controlfiles using the trace file and opening the database in upgrade mode. This worked great!
From here i am a little stuck. Do i need to convert the database first to 64 bit or upgrade the db to 11g? Does this method actually work? i get a few errors relating to the DBMS_STANDARD....
Maybe my only option is to export then import? any advice appreciated.