Home » RDBMS Server » Server Administration » Invalid Row ID
Invalid Row ID [message #241565] Wed, 30 May 2007 01:08 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi Dears

I m using oracle 8.1.5 on windows 2003.

From last 15 days i m facing the problem of Invalid row id in particular table. then i have import this particular problem from the dump file and then it works fine for two or three days but after that the problem come again...

so kindly help us..... why it's so..

regards

Tarun Mittal
Re: Invalid Row ID [message #241566 is a reply to message #241565] Wed, 30 May 2007 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In which do you encounter that?
Do you store rowid in table columns?
Do you rebuild indexes while there are concurrent processes?

Regards
Michel
Re: Invalid Row ID [message #241572 is a reply to message #241566] Wed, 30 May 2007 01:20 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
It's encuonter whenever we perform any action on this paricular table. like insert , select count(*)..... like this

we r not store any row id i think it's oracle internal row id

no we do n't rebuild the index when this patricular table inuse


Regards

Tarun Mittal
Re: Invalid Row ID [message #241610 is a reply to message #241566] Wed, 30 May 2007 02:58 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Kindly suggest
Re: Invalid Row ID [message #241626 is a reply to message #241610] Wed, 30 May 2007 03:57 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You likely something wrong but as I don't know all what you process I can't suggest more than I already did.
Have a very close look at all the treatments.
Sorry.

Regards
Michel
Previous Topic: control file
Next Topic: doubt in database
Goto Forum:
  


Current Time: Sat Dec 03 01:02:36 CST 2016

Total time taken to generate the page: 0.10521 seconds