A tablespace is a data file that stores several tables, such as a zip file? What is the relationship between tablespace and the data file?
A tablespace is a data file that stores several tables, such as a zip file? What is the relationship between tablespace and the data file?
In Oracle, a Tablespace is a logical space, it is the basic storage of all data, effectively the analogy of a container of tables as a zip file is quite close, except that the > tablespace is not a physical container but logical. A database consists of one or more " tablespaces ". Each of these, is managed by one or more Datafiles that these are physical files at the level of the operating system. One way to understand this is, for example, when we manage a huge tablespace and we want to distribute them on different disks, we will have as many datafiles as 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 .