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?
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
BCD
B,C,D