Is an "alter table shrink space" dangerous
755744May 5 2010 — edited May 5 2010Hello,
I have the problem that the tables resp. tablespaces need too much space. I have delete a lot of rows but the tablespaces hasn't become smaller. I have read that I have to use the following commands:
alter table test ENABLE ROW MOVEMENT;
alter table test SHRINK SPACE;
My question: Is it dangerous to use it? And how much time it needed? The shrink command locks the table