Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while table move

user8983130Jul 7 2010 — edited Jul 7 2010
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.........
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2010
Added on Jul 7 2010
7 comments
1,259 views