The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1
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, createdFROM 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:17statement in resumable session ‘User U1(136), Session… Read More »