Home » Developer & Programmer » Designer » how is that a block in a table can have more than one tables record?
how is that a block in a table can have more than one tables record? [message #90686] Mon, 02 August 2004 07:20 Go to next message
Arun chand B
Messages: 1
Registered: August 2004
Junior Member
how is that a block in a table can have more than one tables record?

"This portion of the data block contains information about the tables having rows in this block. "  -- i want the reson for tables.

help would be appreciated.

 

 

 

Report message to a moderator

Re: how is that a block in a table can have more than one tables record? [message #90687 is a reply to message #90686] Mon, 02 August 2004 09:14 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I think that is just bad wording. A table (or index) is a segment. A segment consists of one or more extents. An extent consists of one or more blocks.

If you had a Master and a Detail table, you could create them as a cluster. The common fields (PK, FK) of the two tables would only be stored once so in that regard you could have two tables both having columns in the same block, but not simply different rows from arbitrary tables.

Report message to a moderator

Previous Topic: Using Unicode in Oracle
Next Topic: Schema from SQL Server 2000 to Oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 13:34:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.