Dear all,
I have a question - I have two databases residing in two different hosts -one db is oracle8i and the other is 9i.
Both are connected in a network.
I receive data daily from a live update to the oracle8i db and my task is to come up with a script that would insert these data from the 8i db into the 9i db - the db structures are exactly the same.I need to do this on a 'online' basis.I know creating a *.dmp file and importing into the 9i db would be an option but I cannot do that as i am required to do this on a script - say something like running this in a cronjob at a certain time of the day.
Can anyone please advise me on how to go about achieving this.
Your answers/suggections are appreciated.
thanks and regards.
I have a question - I have two databases residing in two different hosts -one db is oracle8i and the other is 9i.
Both are connected in a network.
I receive data daily from a live update to the oracle8i db and my task is to come up with a script that would insert these data from the 8i db into the 9i db - the db structures are exactly the same.I need to do this on a 'online' basis.I know creating a *.dmp file and importing into the 9i db would be an option but I cannot do that as i am required to do this on a script - say something like running this in a cronjob at a certain time of the day.
Can anyone please advise me on how to go about achieving this.
Your answers/suggections are appreciated.
thanks and regards.