OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Invalid Row ID

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Invalid Row ID [message #241565]

Wed, 30 May 2007 01:08

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

Report message to a moderator

Re: Invalid Row ID [message #241566 is a reply to message #241565]

Wed, 30 May 2007 01:09

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Invalid Row ID [message #241572 is a reply to message #241566]

Wed, 30 May 2007 01:20

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

Report message to a moderator

Re: Invalid Row ID [message #241610 is a reply to message #241566]

Wed, 30 May 2007 02:58

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Kindly suggest

Report message to a moderator

Re: Invalid Row ID [message #241626 is a reply to message #241610]

Wed, 30 May 2007 03:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	control file
Next Topic:	doubt in database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 11:39:34 CST 2024