Re: Relocating undo tablespace

Ed, 'i like the second method because it means I do not have to worry about any dead sessions or uncommitted distributed transactions holding undo entries and slowing things down. Kill everybody and roll back with the shutdown immediate then change the location before anyone can connect. Simple, clean, and reliable assuming you can type the file name correctly on the rename.

I would copy rather than move the file. Then once the database is successfully opened I would remove the old file. Might as well play it extra safe.

You could also just create a new undo tablespace using the new file name and switch over to using it. Once the undo retention period has passed you could then drop the old undo tablespace. Being old fashioned and wanting to get the job done and over with I would take advantage of the window and do what you wanted.

HTH -- Mark D Powell -- Received on Tue Mar 07 2006 - 19:08:53 CST