Re: What does EXCHANGE PARTITION WITH TABLE really do underground ?

IIRC, the data doesn't move, but you will likely have issues with constraints or rebuilding indices. They probably have to be locked to rebuild, and the rebuild probably would get locked out by the dml locks. It's been too long since I've done this sort of thing to remember all the details, but Lewis' Practical Oracle8i book explains what to watch for and test. Even 10g has issues with indices to watch out for.

I think you are going to have to schedule downtime. You might consider upgrading first.

jg

-- 
@home.com is bogus.
http://www.wired.com/news/culture/0,59297-0.html