very urgent

[kusumakar]

can any body help me i had a query
i want to updat tables in oracle 7.1.6 from oracle 8i database
through database link
can it be possible
can any 1 give me solution
or can it be done either way
please revert
thanx
bakshi

[gd_1976]

Hi,
Why can't you write a custom program in front-end tool like VB. Create a DSN one for each database and read from one and update to the other. I did the same way in converting from UNix to WIN NT when i moved the database from one to other.

I think this will work.
Thanks.
Giri.

[marist89]

update tab1 t1
set field1 = (select field1 from remote_tab1@dblink t2
where t1.key = t2.key)

[kusumakar]

do we need to change some parameters in init.ora or something
can we update tables from 7.1.6 to oracle8i db

[hrishy]

Hi

There is absolutely no need to change any init.ora parmeters .Just follow jeffs solution...........................it will work for you.it will work from any version to any version.........

regards
hrishy