Using shape across database links

02-21-2018 12:56 PM
MVP Alum

Has anyone every come up with a solution for pulling shape across a database link? Really tired of maintaining a pile of 200+ python scripts to move data back and forth between databases.

Shape CLOBS are 1.5m in some cases, so i cant convert to text.  


Tags (2)
0 Kudos
1 Reply
Esri Contributor


How to handle Oracle BLOB columns via Database Link 

as an example of ways that developers have been solving this problem.

Also, don't forget WKB for a smaller payload than WKT.

Also, Ask Tom mentions 12.2 and the lifting of some restrictions regarding LOBs:

Ask TOM "Transfer data from one db to another db over db li..."