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