Hello,

I am trying to write a script that retrieves data from a view in an Oracle database and then inserting that data into a Sybase database.

I need to run this script every 5 minutes and retrieve all new data. What is the best way to do this? I have been able to write scripts that have fetched one row, but not multiple rows.

Any hints?

Hello,

I think u can take tha data out in a flat file and then with the use of format file BCP(bulk Copy) in the data into Sybase database and in unix u can make use of sleep function to introduce the wait period of 5 min.

Hope this will work for u,
--pooja