ORACLE 10G
shrink space
1. enable row movement
2.shrink space
alter table test enable row movement;
alter table test shrink space compact; -- shrink HWM
alter table shrink space cascade; --not shrink HWM
query error desciption info
for example:
[oracle@jerry ~]$ oerr ora 1555
01555, 00000, "snapshot too old: rollback segment number %s with name "%s" too small"
// *Cause: rollback records needed by a reader for consistent read are
// overwritten by other writers
// *Action: If in Automatic Undo Management mode, increase undo_retention
// setting. Otherwise, use larger rollback segments
[oracle@jerry ~]$
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16298743/viewspace-1046253/ ，如需转载，请注明出处，否则将追究法律责任。
