I wouldn't think that dropping a 100GB tablespace would generate 100GB worth of redo, even if it is nearly full. I'm thinking that dropping a tablespace is unrecoverable, and thus redo would be minimal. However, you should really try it, on a test system of course.




Reply With Quote