There is a known PITSS.CON issue when you run a Search and Replace. The issue is that after running either a search or a search and replace in PITSS.CON, the following error is produced:

40505 – ORACLE error: unable to perform query

After a few moments, the Search and Replace results will come up. However, the results are blank even though there is a count of objects which should have been returned.

The reason for this is because there is an Oracle bug in the Oracle database hosting PITSS.CON. The solution is to run the following SQL command as a SYSDBA user such as SYS:

alter system set optimizer_features_enable=’′;

Once this is run, the problem should disappear.

Get Our Newsletter