Q131 The ORCL database has RESUMABLE_TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE

Posted on by Tran Anh

Q131 The ORCL database has RESUMABLE_TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA. U1 executes this command:

SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created FROM dba_objects);

U1 complains that the command is taking too long to execute.

In the alert log, the database administrator (DBA) finds this:

2017/3/6 14:45:17 statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA01536: space quota exceeded for tablespace ‘DATA’ Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

  • (A). Add a data file to DATA
  • (B). Drop other U1 objects in DATA
  • (C). Increase U1’s quota sufficiently in DATA
  • (D). Set DEFERRED_SEGMENT_CREATION to TRUE
  • (E). Grant UNLIMITED TABLESPACE to U1
  • (F). Set AUTOEXTEND ON for data files in DATA
Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận