ORA-12853 / ORA-4031

ORA-12801: error signaled in parallel query server P002, instance xt0p-2:stpa2 (

2) ORA-12853: insufficient memory for PX buffers: current 68544K, max needed 15360K

ORA-04031: unable to allocate 131120 bytes of shared memory (""shared pool"",""unknown object"",""sga heap(2,0)"",""PX msg pool"")

3 node rac . parallel query process was spawning to node -2 . increasing the shared pool size fixed the query . and also changed the parallel instance groups.

ORA-14266: data type or length of an index subpartitioning column may

I was getting this error while trying to alter the data type for a column. as per the error . but as per the cause /action for this error there were no indexes/partitions on this column .

was not sure what is going on so i just dropped all the indexes( few normal index and partioned bitmap indexes) for this table and then when i try to do the alter it went fine .