By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.