• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

copy data from one table to another every 30 minutes through a stored procedure in oracle pl sql

 
Pramod Krishna Murthy
Ranch Hand
Posts: 37
Java Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, i have a requirement ,wherin i have to copy or insert the data from table present in one database , to a table present in the other database. this should happen every 30 minutes automatically. i have two fields to use(to select data from). i dont know pl sql . can some one help me on this. i am really in need of this. i have to copy all those data into my database every 30 minutes. please help me on this. i need to know which query i have to use and how do i schedule it to execute every 30 minutes
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic