I have following issue my table has about 100 records, but when opening through "Enterprise Manager Console" I get always pop up message:
Your table has more that 1000 records do you want to define filter query....
This table was imported and first it had indeed some 1000 records. Before using this table now, I have deleted all records.
Running a count statement returns correct number of records.
Does anybody has an idea how to drop non existent records?
Glad it worked out. Look at the above mentioned packages (especially
if you are running the cost based optimizer as opposed to the rule based).
You might want to look at the statistics for the entire schema. You might
be suprised at the results ...
I would advise you try it out on your test system with production data before you do it on a production database. The CBO doesnt always get it right and neither does dbms_stats half the time . NOTE you should configure your test system as closely as possible to your production database i.e. init.ora params etc.