Relation between Database and Tablespaces in Oracle

Q

How a Database Is Related to Tablespaces in Oracle?

✍: FYIcenter.com

A

A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Another database can have three tablespaces, each consisting of two datafiles (for a total of six datafiles).

 

Show All Tablespaces in the Current Database in Oracle

Relations between a Tablespace and Data Files in Oracle

Managing Oracle Tablespaces and Data Files

⇑⇑ Oracle Database Tutorials

2019-01-20, 1514🔥, 0💬