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.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.