• Post Reply Bookmark Topic Watch Topic
  • New Topic

Copying data from one DB to another  RSS feed

 
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

How can i transfer data from one database ( a table) to another database ( another table) using trigger.

Thanks,
Sarika.
 
ranger
Sheriff
Posts: 17314
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok, so you want to copy information that is in one Database instance to another database instance. Look into a DBlink. I think that is what it is called it has been over a year. Then you can access the table just like it was within the same database. You would just refer to the table like table@db_link, where table is the tablename and db_link is the name of the dblink.

Hope that helps

Mark
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!