This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER4%3C/text%3E%3C/svg%3E)
I have a linked server connection between my SQL server and remote Oracle server. I can query the Oracle server from SQL without issue. I need to insert data from SQL into Oracle. The problem is the table names in SQL are different than Oracle. I tried using a select as statement inside the value command and it did not like it.
I was thinking about maybe reading the SQL data into a temp table or variable but wanted to get others thoughts on this.
In theory, you should be able to do:
INSERT ORACLESVR.catalog.schema.tbl(col1, col2, col3)
SELECT ...
FROM localtbl
WHERE ...
But this often breaks down for various reasons. It's usually easier to run the INSERT statement on the target side, but I don't what Oracle supports in that area.
I'm not sure what you mean with using a temp table or table variable. I can't see how that could make things easier.
Thank for your the feedback. The statement you mentioned above is what I am using works perfectly when the values are static. My problem is the data needs to be read from one column into another one and the remote table has a different name
I am not sure I understand. Table and column names on both sides could be different and that should work.
What code are you trying to run and what error message do you get? Or is there some other issue?
My issue was with the syntax. Since this is my first time querying an Oracle server from SQL it took me a couple of times to get things right. Right now the query is working but slow. It takes about 91/2 minutes for 33K records but better than nothing.