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!

i want to move tablespaces to another location

445547May 16 2006 — edited May 17 2006
Hi Guys,

I am facing space outage on my drive where all my table spaces are located.
Now i have three issues
1.The temp tablespace has alot of empty space i want to move it to another location,i know the procedure but i want to make sure whether i can do it while i am still on line
2.My three tablespaces sysaux,system and users are running out of space.
i want to resize them by adding some datafiles,while they are still online.
3.Is there any limitations on which tablespaces you can not move.

I have six tablespaces system,sysaux,temp,users,undotbds and example.

Undotbs,temp and system are on manual segment management
the rest are auto.

i am running oracle 10 on windows

please help
thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2006
Added on May 16 2006
15 comments
1,532 views