Home » Infrastructure » Unix » ri and partition
ri and partition [message #162718] Mon, 13 March 2006 05:44 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4593
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 25 02:33:45 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.