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?

Question

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?

Accepted Answer

B. Add a data file: C. Move a partition to another tablespace: D. Resize the existing data file:

Answer

A. Extend the logical volume by 10 MB where the data files are stored; # lvextend -L+10M /diskl

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…

Question

Options

How the community answered

Community Discussion