Tablespace and Datafiles in Oracle Database : Back to Basics

Image taken from Oracle Documentation Tablespace : is logical storage unit in Oracle Database. ii) Tablespace connsit of one or more datafiles (check below) iii) Information about Tablespace can be obtained from view DBA_TABLESPACES, USER_TABLESPACES, DBA_TEMP_FILES (for Temporary Tablespaces) iv) Tablespace is further divided in to logical units Segments (Segment is divided in to Extent and Extent in […]