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.
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..."