coalesce truths

If you never drop / truncate -- you never need to coalesce.

If you frequently drop / truncate -- these objects belong in their own "special"
tablespace, one that you can coalesce whenever you feel like.


And so, only the sql

Quote:

---

delete, drop, truncate

---

statement comes into this "drop/truncate" situation?

other than that... if we issue a coalesce command, we wont be able to see any positive results?

who on earth needs to coalesce when using LMT?

agreed.. also, i was asking that in the perspective of having DMT databases

Quote:

---

Originally posted by yls177
agreed.. also, i was asking that in the perspective of having DMT databases

---

who on earth needs to coalesce when using DMT with equaly sized extents?