error during compression of table
Hello,
Please refer to below error during compression of table:
I fired the query and it threw error for space crunch in EPICLARGE tablespace after 27 min of execution.
The TEMP tablespace and CPU utilization was normal throughout execution.
11:53:36 SQL> alter table CLARITY.ACC_LOG_DTL_IX move compress parallel 5;
alter table CLARITY.ACC_LOG_DTL_IX move compress parallel 5
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P001
ORA-01652: unable to extend temp segment by 8192 in tablespace EPICLARGE
12:20:29 SQL> 12:20:29
I re-executed the query after adding some space to tablespace EPICLARGE .
I have added space up to 9 datafiles of 32 Gb each