DATABASE MIGRATION FROM SOLARIS TO WINDOWS 2000
Posted on 2004-04-14
need advise for database migration.
Current database oracle 8.16, platform Solaris e-450, os 2.6
New database oracle 9.2, platform window 2000.
Since full export file size over than 2G, the exp file is compressed in **.dmp.Z.
What is the command to uncompress dmp file and import the table to the new database on window 2000?
Dose all the old procedure still usefull?
Is any change on calling a DBA_JOB to schedule auto procedure run?
Please provide me all suggestion from your experience.