i have two databases db1 and db2.db2 is on HP-UX 9000 server and db1 is on win NT.i want to transfer data from one table of db1 to table with same name in db2.
Printable View
i have two databases db1 and db2.db2 is on HP-UX 9000 server and db1 is on win NT.i want to transfer data from one table of db1 to table with same name in db2.
exp/imp, db links and sqlplus copy command
All basic stuff
db link is not working its giving error that
'Could not resolve service name'
as i am giving same service name as in tnsbnames.ora file
db link is server to server - so the tnsnames ON THE SERVER db1 must have an entry for db2 (or vice versa).
thanks dapi there is entry needed in unix server for NT
Quote:
Originally posted by davey23uk
exp/imp, db links and sqlplus copy command
All basic stuff
Ding Ding Ding!!!
Give that man a gold star.