ORA-01410 INVALID ROWID
I have a 10.2.0.5 database which is giving the above error while executing a view. I realise the view is valid. but when executing the view it returns the ORA-01410 error.
can i know based on metalink by executing this command will it have any impact on the production database. Can i execute it safely.
4. Validate the table and indexes.
Run a Validate with the ONLINE clause on the table and its indexes to check for corruptions:
SQL> analyze table <owner>.<table_name> validate structure ONLINE;
--For each index on the table, run a validate also
SQL> analyze index <owner>.<index_name> validate structure ONLINE.