Answer / orawhiz

In Circumstances, all of the data for a row in a table may
not be able to fit in the same data block. When this occurs
, the data for the row is stored in a chain of data block
(one or more) reserved for that segment.

Answer / dinesh

yes that's correct

Answer / pabitra kumar khatoi

In Row chaining basically it happens on the pctused case.
I.e for row insertion case. IF the insert(required) row
size is greater than the available row size then the value
will go to next row . Similarly again if the next row size
is greater than the available row size then the value will
go to next row in a CHAINED manner.That is called Row-
Chaining.

So there is a view called DBA_tables/USER_tables we can get
the column name avg-row_length and chain_cnt .
In the above cloumn we can get the no of row
chaining........

This is the concept of ROW chaining..

If this happen then we can reorg the object.

Difference between an implicit & an explicit cursor.?

2 Answers  

---

Please explain oracle left join with an example?

0 Answers  

---

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

0 Answers   EDC,

---

What is varray?

0 Answers  

---

IS it possible to built the oracle database without setting the kernal parameters?

0 Answers   EDS,

---

Explain what are clusters?

0 Answers  

---

What does a Control file Contain ?

2 Answers  

---

How to convert numbers to characters in oracle?

0 Answers  

---

What is bulk load in oracle?

0 Answers  

---

What is snapshot is too old? Give and example for better understand.

0 Answers   TCS,

---

Is there any function in oracle similar like group_concat of mysql?

0 Answers  

---