Overview of Tablespaces and Datafiles
Let us first understand the logical structure of the database before we look at the tablespace. Tablespace Datafiles Segments Extents Data blocks Tablespaces : Oracle Database consists of one or more logical storage units called tablespace Its collectively store all the database data. Each tablespace consists one or more files called datafiles. Data is collectively stored in the datafiles that constitute each tablespace of the database Image Source: Oracle Doumentations Types of tablespaces There are 2-types of tablespaces there System tablespace Non-System tablespace System tablespace System tablespace created along with database It’s must require in all database Should not contain user data’s Non-System tablespace Enable more flexibility in database administration Control the amount of space to user objects Separate data by backup requirement Creating tablespace Create tablespace <Tablespace_Name> Datafile <Datafie_Locat