How is the optimum number of tablespace we need to create in an Oracle schema ? One for data and one for index ? Thanks

closed as too broad by mustaccio, Leigh Riffel, Max Vernon, billinkc, Balazs Papp Mar 1 '17 at 22:54

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Did you mean how many tablespaces do you need to create? We dont create tablespaces on schema. We create schema(user) objects on tablespace. – JSapkota Feb 28 '17 at 11:25
  • Yes , if we need to create only one Tablespace by schema or one for data and other for index ? – Issam Feb 28 '17 at 11:33
  • Yes, you can create two tablespaces, one for table data and another for Indexes. – JSapkota Feb 28 '17 at 11:41
  • You don't have to have schema-specific tablespaces, but you may want to for application separation. And you don't have to have separate tablespaces for data and indexes. You may have legitimate reasons to do both, but there is no one answer for your general question. – Alex Poole Feb 28 '17 at 12:29
  • The optimum number is the number of tablespaces you need according to your requirements for managing hard disk space. What are those requirements? – a_horse_with_no_name Feb 28 '17 at 15:15

I don't think there is a "rule of thumb" but it really depends upon your hardware configuration.

With different tablespace for every Schema or Index and Data you can differentiate based on the cost or the speed of the disk space.

Not the answer you're looking for? Browse other questions tagged or ask your own question.