A tablespace is a data file that stores multiple tables, like a zip file? What is the relationship between tablespace and data file?
AOverflow.com
A tablespace is a data file that stores multiple tables, like a zip file? What is the relationship between tablespace and data file?
In Oracle, a Tablespace is a logical space, it is the basic storage of all the data, indeed the analogy of a table container like a zip file is quite close, except that the tablespace is not a physical container but a logical one. A database is made up of one or more tablespaces . Each of these is managed by one or more Datafiles that are physical files at the operating system level. One way to understand this is, for example, when we manage a huge tablespace and we want to distribute it on different disks, we will have as many datafileslike disks but a single tablespace. This form of administration allows us to eventually increase the size of a tablespace by adding datafiles according to our needs.
The official documentation here .