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.
正确答案:D
答案解析:有

微信扫一扫手机做题