I've searched and searched and am at a loss here. It seems like something so simple I'm trying to do. Please keep in mind that I'm still very green in the world of SQL. Here is what I'm trying to accomplish.
I have Table1 sitting on a database on Server1. I'm trying to run a query to grab data on Table2 on Server2 and insert that pulled data into Table1 on Server1. I have a connection to the servers done through SQL Developer. A quick sample of what I've tried.....
GRANT INSERT ON Server1.Table1 TO Server2.Table2
INSERT INTO Table1
FROM Table 2
If I just run it to a temp table on Server2, it will work. But I need the data I'm pulling to be housed in Server1. Any suggestions?