You don't mention what Oracle release you are using, but i'm guessing 8.1.7 or older? If so, what you are seeing is a bug when scanning global temp tables, which is fixed in 8.1.7.1 patch.