I have a few 9iR2 oracle small databases running on AIX server in Location A.
DB Sizes runs about 5 GB - 15 GB,
We need to take those out of that location A to Location B which will have a virtual machine.
The O/S on the new machine will be either Red Hat Linux or windows server 2008.
We will install oracle 11g on the new machine and then import the 9i databases over.
What is the best thing to do this:
a) exp/imp (logical dump)
b) create a physical backup in 9i (data files ,control files, etc) and restore from it in 11g.
c) other ways?
Can you advise on the best method.