insert data from table oracle 7 to table oracle 9i

[amalou]

whene i try to insert data on oracle 9i table from oracle 7 table i receive "several error message"
but i can do select * from tab@9i
but whene i do form db7 insert into tab@9i (----) it dont work

 

[ManjulaMadhu]

Hi,

The upgrade /Migration paths from older releases to Oracle 9i is like this:

• For version Version 7:
o Migrate to Oracle 8.0 or Oracle 8i
o Upgrade to Oracle 9i

How are you trying to get data from version 9 to 7 ?
If you are trying through links, then its recommended to have a intermediate ver 8 database and link it 7-->8-->9.