Thanks Jmodic,

But I still have the problems with the mentioned SQLs. Any workarounds. (In these spl cases, I prefix the object name with the owner_name),

I have oracle 8.1.6.