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 File resize

user594143Dec 28 2007 — edited Feb 19 2008

I am dealing with some hard drive space limitation on one of Oracle Database (8.1.7) Windows 2000 Server. While waiting for new hard drive to arrive I want to resize some datafiles which has unused space. One of my questions is it possible to decrease Tempfile from Temp tablesapce. If yes do I have to take tablespace offline. Or this could be done online?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2008

Added on Dec 28 2007

#general-database-discussions

9 comments

25,069 views