I'm in agreement but I have a problem with statement below...
doug.williams (8/11/2009)
In Oracle all Schemas for the DB Instance are held in the a single logical file. Logical because the DB could span multiple files depending on the size and resource configurations.
Oracle storage is organized in tablespaces which are nothing but logical collections of physical datafiles. You can have as many tablespaces as you want.
Moreover, one of the attributes of an Oracle user account is default_tablespace meaning, the place where objects created by that account would go in case the user doesn't bother to specify a particular tablespace.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.