 <p>The answer is correct in a certain context, for simple select statements over a DB link, you'll get this error:</p> <blockquote> <p><strong>ORA-22992</strong>: cannot use LOB locators selected from remote tables.</p> </blockquote> <p>From the errors manual:</p> <blockquote> <p><strong>Cause</strong>: A remote LOB column cannot be referenced.<br> <strong>Action</strong>: Remove references to LOBs in remote tables.</p> </blockquote> <p>I also had trouble finding definitive documentation on this...but we just ran into the same issue in our data warehouse. However, there are several work-arounds available, <a href="http://jiri.wordpress.com/2010/06/04/query-clob-across-db-link-with-in-simple-view/" rel="nofollow noreferrer">pulling the data over or creating a view</a> for example.</p>