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.