1 2 Previous Next 28 Replies Latest reply on Nov 21, 2012 7:18 PM by jgarry

    How Much tablespeces for 10 Schemas

    Maahjoor
      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.

      Regards.
        1 2 Previous Next