Originally posted by nabaig
alter table temp (pctfree 20);

(We aould appreciate it if once in a while, people check out the documentation also) Oracle's the best dcumentation I have come across.

Nizar
Prefectly agree. Specially this one I could have solved by looking into the documentation.

What abt the first question??? I have seen several docs. All docs (including Oracle doc) say only one thing: Chaining is "often" unavoidable for tables having LONG columns. Period. No more explanation.

What does this mean??? Are there any work arounds? The word "often" only sugessts that there are possible solutions in some cases. What are those cases and how to solve them? If you or anyone can get the info from Oracle documentation I would really appreciate.

P.S: I am facing this a real time problem here. I need to fix it as soon as possible.