You have probably all experienced situations where you get an error message from Oracle and it turns out to be a total Red Herring. Occasionally though the error messages can be really helpful. I got an email from a co-worker today (thanks Stephan) that read like this:
I was working on an external table today and fat fingered something. This is the error report-
SQL Error: ORA-30657: operation not supported on external organized table
30657.0000 – “operation not supported on external organized table”
*Cause: User attempted on operation on an external table which is
*Action: Don’t do that!
Gotta love it. They don’t actually tell us what we did wrong, but they do tell us how to resolve the issue!
Apparently some of the Oracle developers have a sense of humor.
By the way, I’m sure you already know this but there is a nifty little Oracle provided tool called oerr that spits out this information:
SYS@SANDBOX1> !oerr ora 30657 30657,0000, "operation not supported on external organized table" // *Cause: User attempted on operation on an external table which is // not supported. // *Action: Don't do that!