Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization’s Data

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024

M. Malcher, D. KuhnPro Oracle Database 23c Administrationhttps://doi.org/10.1007/978-1-4842-9899-2_4

4. Tablespaces and Data Files

Michelle Malcher¹   and Darl Kuhn²

(1)

Huntley, IL, USA

(2)

Morrison, CO, USA

 

Tablespaces are not just for tables. A tablespace is a logical container that allows you to manage groups of data files, the physical files on disk that consume space. Once a tablespace is created, you can then create database objects (tables and indexes) within tablespaces, which results in space allocated on disk in the associated data files.

A tablespace is logical in the sense that it is visible only through data dictionary views, such as DBA_TABLESPACES ...