4
A tablespace is a data file that stores multiple tables, such as a zip file? What is the relationship between tablaspace and data file?
2 answers
3
Tablespace is a place to store data files. The data file usually has several tables, but nothing prevents it having only one or even a part of a table. Indexes also.
Usually each Tablespace is on a different storage drive and is a logical organization, precisely to be able to differentiate where the files will be. It’s just a facilitator to indicate where the data is physically.
Is known namespace of programming languages, it’s basically this, it’s just a way of naming a set of smaller things.
1
Tablespace corresponds to a logical area where the oracle stores the collection of files that make up the database, datafiles are the physical files themselves.
Browser other questions tagged database oracle
You are not signed in. Login or sign up in order to post.