Hi:

Oracle : 8.1.6
O.S. : window NT

I exp. the table from one database and imp. to another one..
and tested and it was working..

Then I dropped the index and recreated the index with out any changes (same as before) and it is not working..

Also, I analyze the index and still not working..

I know I could rebuild the index without dropping and recreating..

If you have any suggestion, plese let me know...

Thanks..