Home » RDBMS Server » Server Administration » index rebuild offline
index rebuild offline [message #64139] Tue, 21 December 2004 19:52 Go to next message
jofer
Messages: 1
Registered: December 2004
Junior Member
Can index rebuild offline can cause ORA-01410: invalid ROWID? That is only a select use in a report.

Thanks!
Re: index rebuild offline [message #64146 is a reply to message #64139] Wed, 22 December 2004 01:08 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

I would not think so, unless you are hitting some strange bug.

Do an explain plan to see if the index is being used. If it is, disable it with a hint and see if you still get the error.

Best regards.

Frank
Previous Topic: Database not start
Next Topic: analyze table problem in oracle 9i
Goto Forum:
  


Current Time: Thu Jan 09 22:39:09 CST 2025