OraFAQ Forum: Server Administration » More than 1 ROWIDs for 1 single record

Home » RDBMS Server » Server Administration » More than 1 ROWIDs for 1 single record

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

More than 1 ROWIDs for 1 single record [message #116000]

Fri, 15 April 2005 17:47

win_vj
Messages: 16
Registered: March 2005
Location: India

Junior Member

Hi,

I have a table on Production. That table has a primary key. But today when i checked the records on the basis of that primary key, It gave me more than values for a same record. I checked that primary key in USER_CONSTRAINTS,and it was there. Then i checked the ROWIDs again it gave me 3 values.

1. select * from a where id='1';
----Here id is a Primary Key, even then this query returned 3 rows

2. select rowid from a where id='1';
----Here it returned 3 ROWIDs

Now My question is how dupliacy happened in Primary Key field and How there are 3 ROWIDs for a same record?

Thanks n Regards
Vijay

Report message to a moderator

Re: More than 1 ROWIDs for 1 single record [message #116007 is a reply to message #116000]

Fri, 15 April 2005 21:46

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

check the status of the constaint.
It should be disabled.
And post what you are doing!.

Report message to a moderator

Re: More than 1 ROWIDs for 1 single record [message #116054 is a reply to message #116000]

Sat, 16 April 2005 22:32

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Yep, definitely check status of constraint as enabled or disabled. And check whether or not it is validated and rely.

Report message to a moderator

Re: More than 1 ROWIDs for 1 single record [message #116259 is a reply to message #116000]

Mon, 18 April 2005 22:36

chunyuh
Messages: 13
Registered: April 2005

Junior Member

if you enable the unique constraint with novalid option, it's possible that the table holds duplicated rows.

Chunyu Hu
http://mtsmart.kmip.net

Report message to a moderator

Previous Topic:	ora -01691 Unable to extend LOB...
Next Topic:	A problem of Unix connected Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 04:55:03 CST 2025