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
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.
update tab1 t1
set field1 = (select field1 from remote_tab1@dblink t2
where t1.key = t2.key)
do we need to change some parameters in init.ora or something
can we update tables from 7.1.6 to oracle8i db
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.........
Click Here to Expand Forum to Full Width