We’re still on 9.6 and I can’t download the beta or a newer version here at work
– in some ways, we’re more locked down than Norm.
But I just had a surprise. I was trying to compare data between the same table
on two instances, using a DB link. And because the tables included a CLOB
column, I got an access violation.
I wasn’t going to try to compare the CLOBs anyway. But Toad died when it was
populating the column list, before I even had the chance to uncheck those
columns. Looks like the only way to do this with my version is to build a view
that doesn’t include the CLOB on the remote instance, so that’s what I’ll do.
Database is 11.1, client is 11.1, I can repeat and generate a support bundle if
there’s any need.
I can live with this until our powers-that-be decide to release a newer release.
No significant business problem, no support required.
But I wanted to report it on the oft-chance that it might not have been
discovered and fixed in the intervening versions.
So somebody who has rights to a current version or the beta should test a data
compare across a DB link when the tables contain a CLOB. See if you can select
non-CLOB columns and compare data from them.
– jim
James F. Hudson
Wisconsin Department of Natural Resources
Madison, WI
(608) 267-0840