topic Using shape across database links in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/using-shape-across-database-links/m-p/869396#M6191 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Shape CLOBS are 1.5m in some cases, so i cant convert to text.&nbsp;&nbsp;</P><P></P><P>Thanks</P></BODY></HTML> Wed, 21 Feb 2018 20:56:46 GMT JeffPace 2018-02-21T20:56:46Z Using shape across database links https://community.esri.com/t5/geodatabase-questions/using-shape-across-database-links/m-p/869396#M6191 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Shape CLOBS are 1.5m in some cases, so i cant convert to text.&nbsp;&nbsp;</P><P></P><P>Thanks</P></BODY></HTML> Wed, 21 Feb 2018 20:56:46 GMT https://community.esri.com/t5/geodatabase-questions/using-shape-across-database-links/m-p/869396#M6191 JeffPace 2018-02-21T20:56:46Z Re: Using shape across database links https://community.esri.com/t5/geodatabase-questions/using-shape-across-database-links/m-p/869397#M6192 <HTML><HEAD></HEAD><BODY><P>Consider:</P><P></P><P><A class="link-titled" href="http://www.stefan-armbruster.com/index.php/14-it/oracle/29-how-to-transfer-oracle-blob-clob-via-database-link" title="http://www.stefan-armbruster.com/index.php/14-it/oracle/29-how-to-transfer-oracle-blob-clob-via-database-link">How to handle Oracle BLOB columns via Database Link</A>&nbsp;</P><P></P><P>as an example of ways that developers have been solving this problem.</P><P></P><P>Also, don't forget WKB for a smaller payload than WKT.</P><P></P><P>Also, Ask Tom mentions 12.2 and the lifting of some restrictions regarding LOBs:</P><P><A class="link-titled" href="https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9537173800346843052" title="https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9537173800346843052">Ask TOM "Transfer data from one db to another db over db li..."</A>&nbsp;</P><P></P><P>-Dale</P></BODY></HTML> Sun, 11 Mar 2018 07:18:31 GMT https://community.esri.com/t5/geodatabase-questions/using-shape-across-database-links/m-p/869397#M6192 DaleBrooks 2018-03-11T07:18:31Z