Truncate Table Over Linked Server to Oracle

• amy26

  SSCrazy Eights

  Points: 8926

  More actions

  January 28, 2019 at 2:32 pm

  #381273

  Is there any way to do a table truncation across an oracle linked server?  I have looked up methods to do with linked servers but only found solutions for sql server to sql server linked servers.  I can do a delete openquery but OMG its slow as piss and hoping there was another way.  I have to do a data load to Oracle but they want  me to clear out the table first before I push it.

• frederico_fonseca

  SSCoach

  Points: 16154

  More actions

  January 28, 2019 at 2:34 pm

  #2020343

  openquery with truncate may work - if not create a stored proc on oracle that does the truncate for you and exec it through openquery