var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Connection Between Two Database
i have two db
the first is running under 0RACLE 8i under unix
the second is running under 9i
i fill like to link the two databade in order to tranfer data(table) every morning from the first database to the seconddatabase
can you you help me please
yaya from west africa senegal
U can create a db link then use a trigger to insert the values u need to the database u need using this dblink.
CREATE DATABASE LINK db_linkname
CONNECT TO username IDENTIFIED BY password
Test the dblink by:
SELECT * FROM anytable@db_linkname;
Use trigger to insert into this table sing the dblink.
Give it a try ,pls let me know.
where am i going to create this dblink
in first db or second db
after this how can i config network to access to this db because the thwo db are not the same pc and not in the same town
U can configer a replication enviornment so to make both the databases upto date.
U can use OEM to Configer the Replication enviornment.
U can create links in both if u need data transfer from both.
the problem is the two db are not in the same computer
I am not fully sure of the solution I am writing, but couldnt CRON the job, and use triggers.
What the cronjob would probably do is insert or update a row in an UPDATE table, and this would trigger off the routine.
Any ideas ... andrewst.
Thanx and Regards