Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?()
A:Oracle Data Pump.
B:An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
C:An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
D:Online Table Redefinition.
E:Edition-Based Table Redefinition.
出自:Oracle认证