Yes that is true, where a Tablespace is a collection of database objects. M Most Oracle Database DBAs will set up a default Tablespace "USERS" this tablespace is usually the default that you speak of. The DBA will also set up additional tablespaces depending on the design and utilization of the DB. For example a large block tablespace may be initialized for objects that will most frequently be large in size for each instance. There by tuning the tablespace to provide faster response, Versus a tablespace for indexes, which would be relatively small per instance. and so on....

Without getting into semantics about management of Oracle tablespaces, I was just trying to point out that the management requirements for one greatly out weigh the other.

Doug 😎