Originally posted by sfdba
THE ENTIRE INDEX TABLESPACE WILL HAVE TO BE DROPPED AND RECREATED.
BUT >DROP TABLESPACE INDX INCLUDING CONTENTS; WILL GIVE ERRORS ORA-00604, ORA-02429
arent you complicating your life...? just disable the primary keys and enable them later