How is the optimum number of tablespace we need to create in an Oracle schema ? One for data and one for index ? Thanks
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.