Database Administration (MOSC)

MOSC Banner

ORA-01410 INVALID ROWID

edited Sep 30, 2015 10:03AM in Database Administration (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center