I don't think it neccessary to drop the indexes -- you can rebuild in parallel and nologging etc anyway.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Reply With Quote