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.

 

 

 
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: 2574
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.
Previous Topic: Using Unicode in Oracle
Next Topic: Schema from SQL Server 2000 to Oracle 9i
Goto Forum:
  


Current Time: Mon Sep 22 22:10:06 CDT 2014

Total time taken to generate the page: 0.07919 seconds