Is it ok if I coalesce thr RBS table space....
Does it create any probs....
Ive issued the commit buts till it xists
You cannot colasece a rollback tablespace only shrink the rollback segments to a particular size or to its optimal value.
In addition, you should never NEED to coalese an RBS tablespace since the PCTINCREASE is zero.
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."