OraFAQ Forum: Unix » ri and partition

Home » Infrastructure » Unix » ri and partition

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

ri and partition [message #162718]

Mon, 13 March 2006 05:44

raom
Messages: 22
Registered: January 2006
Location: india

Junior Member

hi
can any body tell me what is the relation between ri and partition in a database.for partitioned database

Report message to a moderator

Re: ri and partition [message #163187 is a reply to message #162718]

Wed, 15 March 2006 07:02

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

What is ri? Can't you type proper sentences?

Report message to a moderator

Re: ri and partition [message #163276 is a reply to message #163187]

Wed, 15 March 2006 22:09

raom
Messages: 22
Registered: January 2006
Location: india

Junior Member

thanks for the reply
well my question was is there any relation between the number of rows in a table and partition number in partitioned database.
ri is rowid.

i have seen one such calculation like below
the starting rowid of a table in partitions 1 is

ri=power(2,28)*partition

is that true if yes how is it derived.

Report message to a moderator

Previous Topic:	How to create partition for RAW disk devices of specific sizes
Next Topic:	Oracle 10G Release 2 on Solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 18:04:48 CST 2024