hello
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

hi yaya,

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
USING 'DBNAME';

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.

..mickykt

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.

......micky

how to do that

the problem is the two db are not in the same computer

Hi
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