copy contents of one field to another field in another database

[openeratech]

Hi,

I have to copy contents of one field to another field in another database,

I am using Oracle 8 on Windows 2000 server.

Please tell me how can i do it.

Thanks
Yunus

 

[hoinz]

read about database link
hth

 

[SantaMufasa]

Opener,

Hoinz's suggestion is right on the money. Also, knowing how much trouble I had originally figuring out how database links worked, I thought I would pass along some simple samples for you of a syntax option to create at database link, then an example of how to use a database link to both access and update a remote database.

First, I have a database on a machine on our network that is 750 miles away on the West Coast. The alias that I have in my tnsnames.ora for that database is RIV817. Here then is my code to create a database link to the SYSTEM user on that database:

create database link RIVER
   connect to SYSTEM identified by <SYSTEM password goes here>
   using 'RIV817';

Database link created.

Then to access yet another schema in the remote database:

select * from dontdrop.dummy@riv817;

X
---------
£
1

2 rows selected.

To update the remote database, you can say:

update dontdrop.dummy@riv817
set x = '$' where x = '£';

1 row updated.

select * from dontdrop.dummy@riv817;

X
---------
$
1

2 rows selected.

Then, to illustrate that you have full consistency control over even a remote transaction:

rollback;

Rollback complete.

select * from dontdrop.dummy@riv817;

X
---------
£
1

2 rows selected.

Does this give you the illustration you need to take care of business?


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Turkbear]

Hi,
Just one added note about a very common 'gotcha' when using Database Links:
The tnsnames.ora file On the Oracle Database Server , Not the client PC is the one that needs to have the entry for the remote database instance..

I usually test my DB LInks right after I create them by using a
select sysdate from dual@Remote

It will indicate any problems with the link and usually is very fast.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

Good point of emphasis, Turkbear. (BTW, [and not wanting to take this thread off into the weeds...I imagine that the weather 30 miles south of Dublin on a summer's day like today must be amazing, true or false?)

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Turkbear]

Hi,
Actually, I am in Minnesota - but the weather is great this time of year ( assuming you like 90s and high humidity) - makes up for the -20s F and low humidity in the Winter...






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[openeratech]

Hi,

thanks everyone for their help. I got this one sorted out by using utility DB Commander Pro.

As i am not a full time DBA so i dont understand most of the things explained above. I was looking for some easy solution.

But anyways my word of thanks is for all who helped me.

Cheers
Yunus

 

[Turkbear]

Hi,
Glad you found a way to get it done, but, if you are going to be held accountable for DBA type work, especially with a complex system like Oracle, you need to get some training or at least do lots of reading...Oracle is not a simple beast to tame...








To Paraphrase:"The Help you get is proportional to the Help you give.."