-
i am new to dba and i am working on oracle 8i but our company want to port to oracle 9i and i want to migrate my database to oracle 9i.
i have got a clean install of oracle 9i on redhat 7.1 with all the required parameters.i also made a default database and it up and running.
i now want to migrate my oracle 8i to 9i without using the utilities given my oracle o r say manually.
please let me the procedure.
thanx
-
IS both your databases 8i and 9i on the same server. On that case use oracle data migration assistant. Otherwise use export and import (personally I would prefer this)...
Sam
-
oracle 8i and oracle9i
thanks sam,
but they r not on same server as both the requirement for 8i and 9i r different.
8i need glibc 2.2 kernel-2.1.4
9i need glibc 2.2 kernerl -2.2.2
but exp and import such a huge database would take a lot of time.
saurabh
-
Do a Full export of 8i and then import it into 9i. You could also look into that of using oracle migration work bench.
Sam