i want to move tablespaces to another location
445547May 16 2006 — edited May 17 2006Hi 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