sql - Insert into table on the Linked Server with Data from local table -

i'm working sql server express, created linked server oracle database.

as title indicates, want insert data selected local table table @ linked server.

i tried many queries no 1 of them worked want.

this query below used has worked, static values, want insert data dynamically table on local database.

insert openquery (ortest, 'select * reservation') values (2, '2', 3); 

you should able use linked server name part of qualifying table name, , normal insert select:

insert ortest.[dbname].[dbo].[reservation] select * [dbname].[db].[reservation]