Originally Posted by feroz 1) create new temporary tablespace 2) move out data to temp tablespace 3) drop old tablespace 4) recreate old tablespace 5) move back in from temp tablespace Yup.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Originally Posted by feroz
Reply With Quote