MINUS Query Problem

Hi,

I am having a strange problem with a MINUS query under Oracle 8.1.5.

Some users are able to execute the MINUS query and return the expected rows, while others do not get a response (ie. the query is executed under SQL*Plus and SQL*Plus just seems to stop responding). The users who do not get a response can successfully return the expected rows from each part of the MINUS query.

I realize that I have not provided much background information here, and at first I thought it might be a security-related problem. It just seems strange that a user who can retrieve the expected rows from each part of the MINUS query cannot retrieve any rows from the full MINUS query.

Any ideas on this?

Thanks,

Dave Received on Mon Dec 04 2000 - 16:37:35 CST