Database Administration (MOSC)

MOSC Banner

error during compression of table

edited Nov 6, 2014 10:05AM in Database Administration (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center