Answer Posted / 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.

Is a rollback possible to any savepoint?

998

---

What is a view and how is it different from a table?

969

---

Oracle

2319

---

what is port in oracle? how is it related to database application.

1893

---

How to start a specific oracle instance?

990

---

candidate key is subset of super key but not vice-verse explain

2016

---

How to add a new column to an existing table in oracle?

1069

---

how can we store any pdf file in oracle

2094

---

How to resolve the ORA-39133 error in Oracle?

1032

---

How to drop an index in oracle?

1019

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1056

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2574

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

---

How do we represent comments in oracle?

1000

---

What is key preserved table?

959

---