huh. I have’t been making any changes in the SB code lately. This is the same error message you were seeing in Copy Table Data a month or so ago. I was never able to reproduce it, and as I recall, it went away after you restarted.
Can you turn on spool SQL so I can see what query this is coming from?
This is the last SQL, which seems reasonable since it only happens on table with an FK.
WHERE OWNER = ‘CHX_COMMON’
AND TABLE_NAME = ‘HOST’
AND CONSTRAINT_TYPE = ‘R’;
I can’t reproduce this, Dale. And I don’t know why you would be getting this message, either. This is 64 bit, right?
I’m not sure if it’s relevant, but what is your Oracle client version? Does the error go away like it did before if you restart Toad?
Using 126.96.36.199 client. And, yes, no error after restarting Toad.