-
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
-
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.
-
update tab1 t1
set field1 = (select field1 from remote_tab1@dblink t2
where t1.key = t2.key)
Jeff Hunter
-
do we need to change some parameters in init.ora or something
can we update tables from 7.1.6 to oracle8i db
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|