Using Database Control, you have scheduled a job to shrink the TRANS
table residing on the TT tablespace. The job would run at 5:00 p.m. e
very Friday. When you examine the space usage of the table after the
completion of the job, you find that the table has not been shrunk. W
hat could have b een the reason for this?
A. The tablespace that contains the TRANS table is online.
B. The tablespace that contains the TRANS table is permanent.
C. The tablespace that contains the TRANS table is locally managed.
D. The segment space management of the tablespace that contains the T
RANS table is manual in nature.
Improved performance and space utilization
• Indexes maintained
• Triggers not executed
• Number of migrated rows may be reduced
• Rebuilding secondary indexes on IOTs
2、表段所在表空间的段空间管理(segment space management)必须为auto
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-717821/，如需转载，请注明出处，否则将追究法律责任。