Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2012-02-02 : 13:31:35
|
| Good Morning Team:I need your help. I am using a linked server to Oracle from SQL 2005. I have a table in SQL 2005 and I want to Insert the same info into an Oracle Table. This is what I have done so far but I am missing something. ------------------------INSERT OPENQUERY (US-UPGTest, 'SELECT * FROM dbo.DRCP_LDAP_ACCOUNTS')VALUES ('NewTitle');Insert Statement, Open Linked Server, Select The Table from SQL 2005,----But I am missing how to put the name for the Oracle Table. -----------------------------Thank You, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-02 : 13:34:36
|
| [code]INSERT OPENQUERY (US-UPGTest, 'SELECT * FROM YourOracleTablehere')SELECT * FROM dbo.DRCP_LDAP_ACCOUNTS'[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2012-02-02 : 13:36:46
|
| Thank you so very much Visakh16. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-02 : 13:50:29
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Linked Server to Oracle