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.
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)...
oracle 8i and oracle9i
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.
Do a Full export of 8i and then import it into 9i. You could also look into that of using oracle migration work bench.