Skip to Main Content
Forums

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!

alter table move?

rootsmanDec 1 2009 — edited Dec 1 2009
Hi guys!

Im trying to do reorganization of tablespace objects and im moving tables thru diffrent TB's so that HVM can release empty blocks, but i now have problem.
I have one big table 1,6 Gb of data and i need to move it to tablespace REORG in order to release some blocks. REORG has 1.7 Gb size and when i do this


alter table USER.TABLE move tablespace REORG

i get this error

ORA-01652: unable to extend temp segment by 16384 in tablespace REORG

so what you propose ?

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2009
Added on Dec 1 2009
#general-database-discussions
3 comments
1,034 views