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...