Examine the statements: SQL> CREATE TABLESPACE MYTBS DATAFILE `/disk1/mytbs_l.dbf ` SIZE 10M; SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) ) PARTITION BY RANGE(id) ( partition pi values loss than (100000) tablespacemytbs storage (initial lm), partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m) ); When inserting data, you get the error: ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS Which three operations would allow you to insert data without getting the error message? 

Answer options:

A. Extend the logical volume by 10 MB where the data files are stored;# lvextend -L+10M /diskl
B. Add a data file:SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ` /disk1/mytbs_2 .dbf SIZE 10M;
C. Move a partition to another tablespace:SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE `/disk1/additional_tbs_1 .dbf` SIZE 10M;SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;
D. Resize the existing data file:SQL> ALTER DATABASE DATAFILE `/diskl/mytbs_l .dbf` RESIZE 20M;E) Remove a data file:SQL> ALTER TABLESPACE MYTBS DROP DATAFILE `/diskl/mytbs_l - dbf`;

BCD