This discussion is archived
1 2 Previous Next 28 Replies Latest reply: Nov 21, 2012 11:18 AM by jgarry RSS

How Much tablespeces for 10 Schemas

Maahjoor Newbie
Currently Being Moderated
Dear all,

i have oracle database 10g installed.

i have 10 different schema's. HRMS,INVENTORY,FINANCE etc.
i have 500 users, but it could grow, since it is a college system.

i have only one tablespace with one datafile.

i want to know that how much tablespaces i should use for these 10 schema to be a better approach?

one seperate tablespace for each schema?

i want to know the better and smart approach.

1 2 Previous Next


  • Correct Answers - 10 points
  • Helpful Answers - 5 points