Oracle – Introduction to Databases, tablespaces, and datafiles

Databases, tablespaces, and datafiles are closely related, but they have important differences. It is important to know the differences for Newbie that‘s why sharing here. Databases:  An Oracle database consists of one or more logical storage units called tablespaces that collectively store all of the database data. Tablespace: Each tablespace in an Oracle database consists of one or more files called datafiles. Datafiles:  A database’s data is collectively stored in the datafiles that constitute each tablespace of the database. For

» Read more