In Oracle, a schema is a logical container that stores database objects such as tables, views, indexes, sequences, procedures, functions, etc. A schema is owned by a database user, and the user can manipulate and manage the schema objects. In other words, a schema is a collection of objects that belong to a user.
On the other hand, a tablespace is a physical storage location that stores the database objects. A tablespace can contain multiple database objects, and multiple tablespaces can be created within a database. Tablespaces are used to control the allocation and use of disk space for database storage.
To summarize, a schema is a logical container for database objects owned by a user, whereas a tablespace is a physical storage location for database objects. A schema is a logical entity, while a tablespace is a physical entity. In Oracle, a user can have multiple schemas, but a schema can only be owned by one user. Similarly, a tablespace can contain objects from different schemas.
I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I am working at Cotocus. I blog tech insights at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at I reviewed , and SEO strategies at Wizbrand.
Please find my social handles as below;
Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at PINTEREST
Rajesh Kumar at QUORA
Rajesh Kumar at WIZBRAND
