Simple query makes Oracle hang

From: <faheemrao_at_my-deja.com>
Date: Mon, 08 Jan 2001 23:01:09 GMT
Message-ID: <93dgrg$f4s$1@nnrp1.deja.com>

I have a problem in running a simple SQl query.

This is very strange that the following query makes all oracle front end tool makes "not responding". including sql plus and Oracle worksheet.

select file_name from Filatable
where filetypeID= 2
and
FileCategory NOT IN ( select filecategory from fileCat)

But if omit the not operator that query runs fine.

select file_name from Filatable
where filetypeID= 2
and
FileCategory IN ( select filecategory from fileCat)

I am badly struck with that problem.

any help would do a lot

Thanks in advance.

Faheem Rao

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 08 2001 - 17:01:09 CST