Re: Lost rows after changing MAX_ROWS on 4GB table
The ALTER TABLE created a new table, copied all data over, dropped the old one, and renamed the new one.
The smaller size of the new table might result from deleted rows in the old table, which are not copied over.
The lost rows might be a statistics mistake in the old table. Did you run CHECK TABLE before the ALTER TABLE?
If you want to be sure, rename the new table, and restore the old table from a backup. Run CHECK TABLE on both. If the number of rows is still different, run a proper JOIN to find the rows in the old table, that are missing in the new table.
Subject
Views
Written By
Posted
6315
August 15, 2005 07:26AM
Re: Lost rows after changing MAX_ROWS on 4GB table
2868
August 16, 2005 03:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.