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!

Moving undotbs tablespace datafile to new location

964169Apr 23 2013 — edited Apr 23 2013
Dear gurus

I'm planning to move undotbs datafile to new location

Is there any proper way to do that without loosing any data and without shut down oracle ?

I can't modify the undotbs tablespace name since it's defined in our startup pfile

I've tried to search for some tuts, but still not sure if it'll loose my data or not

Thank you
This post has been answered by Fran on Apr 23 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2013
Added on Apr 23 2013
5 comments
919 views