An index-organized table (IOT) called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?()
A:EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
B:ALTER TABLE … COALESCE ;
C:ALTER INDEX …REBUILD ONLINE;
D:CREATE TABLE …AS SELECT_ONLINE;
出自:Oracle认证