First, make sure that you change (using ALTER USER) each user's default tablespace to one other than SYSTEM, and give each user a space quota on each tablespace they will be using. Then use ALTER TABLE MOVE to move tables to another tablespace, and ALTER INDEX REBUILD to move indexes.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.