I need a comprehensive explanation of the oracle tablespaces... More like Understanding Tablespaces for dummies.
How to modify the default tablespace and reason why one might have to.
And also tablespace creation.
N.B: Need industry experienced people who can relate with real life situations.