Unanswered: rows still present after delete & commit?
am attempting to clear out a production environment prior to an import.
ran my clear_all.sql script successfully which is just a series of DELETE FROM commands.
However after logging back into Enterprise Manager the tables in my tablespace are all reporting the same number of rows as before.
In a sqlplus session any select statement performed on any tables returns 'no rows selected'.
So i think all my tables are empty but i am confused by Enterprise Manager and i have to be sure as it is a production environment.
Has anyone seen this before?
i have logged this with metalink but the response time is quite long.
i was in the administration tab on tables for the relevant schema.
it shows all tables in the tablespace, whether they are partitioned and how many rows they contain.
i am now sure it's a problem with Enterprise Manager - and i've just had a response from metalinks. They say to trust the result of a sqlplus query.
So i've been transferred to the Enterprise Manager section.
So, I'm guessing you are in Grid Control, not just the Enterprise Manager client. In Grid Control, the column next to "Rows" is "Last Analyzed". This column indicates the last time the table was analyzed and that stats were updated.
I am pretty sure that the Rows column is not dynamic, but is the number of rows that were present the last time stats were gathered for the table. If you analyze one of the tables with no rows, the rows column would be updated and accurate.