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!

TEMP tablespace resize

437747Jun 10 2005 — edited Jun 23 2005

A mistaken sort has caused the temp tablespace to grow to big and I need to reclaim the space. We are running Oracle 9.2 on windows 2000. I tried:
alter database tempfile 'filename' resize 4m and got file contains user data beyond requested resize value. How can I reclaim this space?
Thanks,
Felicia

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 21 2005

Added on Jun 10 2005

#general-database-discussions

5 comments

484 views