問題文
A table inside a tablespace that manages its segment space automatically is put forward for an online shrink and the request is refused. Which statement about what keeps a segment out of that operation is correct?
選択肢
- The operation is confined to that kind of tablespace and inside one every table is eligible whatever it carries, so the refusal has to come from the room in the tablespace rather than from anything about the table.
- The operation is confined to that kind of tablespace and even inside one a table that carries the basic form of table compression is left out of it, so the form of compression has to be checked before the request goes in.
- The operation reaches a tablespace of either kind of segment space management and every table inside one is eligible, so the refusal has to come from a lock that another session was holding upon the table at that moment.
- The operation reaches a tablespace of either kind of segment space management and a table that carries the basic form of table compression is left out of it, so the kind of tablespace has nothing to do with the refusal here.