Hello Oracle gurus
We have our current database server (a Sun E220R) and a new server (a faster E480R). The DBA at our hosting company proposed to do an export and then import in the new oracle instance. I am a bit sceptical at this approach because this means that it takes a lot of time to do this (our DB is now 5GB) and this caused some problems with interMedia as well (since the interMedia objects are owned -at least some of them- by ctxsys).
I have seen, at least 3 years ago, an Oracle consultant copy the files from the first server into the second one (since both are the same architecture and oracle version) and then just move the datafiles (and change the references in oracle to them). If my memory is not betraying me, this seems like a better approach, right? How would you recommend doing this? Does the export/import approach seems like a good one?
Any comment/suggestion is welcome!
Thank you in advance.