I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer
Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node
Question is what is best way to do this ?
I surfed & found that oracle SQL Developer can help check this Link
Does this will work ?? Or I have to fallow RMAN cloning option ?
What is best suitable way for doing this ?
expdp
andimpdp
are probably a lot more efficient than using SQL Developer for this. If you can create a DBLink you don't even need intermediate files for that