Error while table move
Dear all,
after deletion of data,when i tried to move one my table to reclaim space,i got the following error:
SQL> ALTER TABLE users.TEXVISATCR MOVE TABLESPACE users NOLOGGING PARALLEL;
ALTER TABLE users.TEXVISATCR MOVE TABLESPACE users NOLOGGING PARALLEL
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P001
ORA-01652: unable to extend temp segment by 8192 in tablespace users;
i have increased undo tablespace and temp tablespace.But still this error exists.
How to resolve this problem???
Thanks and regards.........