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

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

| improve this answer | |

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