Re: why need to backup undo tablespace?

From: Denis Do <nospam.denisdo_at_yahoo.com>
Date: Sun, 12 Dec 2004 10:09:06 GMT
Message-ID: <slrncro61g.rc.nospam.denisdo@denisdo.news.google.com>

> but if you lose undo tablespace and no backup, you still can
> recreate the undo tablespace.

Have you tried it? :-)
Good example - take a kind of big partitioned table, put real load on it, run long transaction and start collecting statistics at the same time. :-) Yes, it is should not be done like that - but it is happening quite often. And kill smon:-) (or shutdown abort)
And try restore without undo TS:-)

Well, if you still looking for fun and adventures - you can try it. If you want to get job done - please do not do it

Have a great day! Received on Sun Dec 12 2004 - 04:09:06 CST