I have just found out that users have created tables on the system tablespace. If i use the ALTER TABLE xxx MOVE TABLESPACE xxx command to move these tables to a diferent tablespace, what are the implications of the constraints and indexes on the respective tables?? Do i have to disable constraints and rebuild indexes??..The indexes are situated in their default tablespace.

Many Thanks