Tablespace and data files in Oracle

4

Is a tablespace a data file that stores multiple tables, such as a zip file? What is the relationship between tablapace and data file?

    
asked by anonymous 11.08.2017 / 23:10

2 answers

3

Tablespace is a place to store data files. The data file usually has multiple tables, but nothing prevents you from having one or even a part of a table. Indexes too.

Generally each Tablespace is on a different storage drive and is a logical organization, just to be able to differentiate where the files will be. It's just a facilitator to indicate where the data is physically.

If you know namespace of programming languages, it's basically this, it's just a way of naming a set of minor things.

Withdrawn documentation .

    
11.08.2017 / 23:22
1

Tablespace corresponds to a logical area where oracle stores the collection of files that make up the database, datafiles are the physical files themselves.

    
12.08.2017 / 00:18