السادة الأخوة الأعزاء اشكركم شكرا جزيلا علي مشاركاتكم المفيدة وجعلها الله في ميزان حسناتكم ان شاء الله
ارجو مساعدتي وتقديم اقتراحاتكم بخصوص تحويل قاعدة بيانات من 9i ال 10g
او بمعني ادق
how can I use logical backup (dmp) exported from 9i database and import it in database 10g
افدادكم الله ( كان الله في عون العبد ما كان العبد في عون اخية)
وجزاكم الله خيرا ان شاء الله

there is a solution to import a dump 9i to 10g is that u must export your logical data that reside in oracle server9i with the EXP.EXE 10g utilities, and after to import it into the oracle server 10g with IMP.EXE10g utilities

did we can use simple export and import ?

- take your dump from db 9i by 9i utility
- put the dump in db 10g by 10g utility
- the database triggers my be lost after importing the dump
- you need to chcek you may create them or compile again
- i tried this method and it works from 9iR2 to 10gR2
good luck