What Is A Data Block And What Is A Data File? Please Explain Briefly?

1.	What Is A Data Block And What Is A Data File? Please Explain Briefly?
Answer» A DATA block is nothing but a logical SPACE where the Oracle database data is stored. A data FILE is nothing but a file where all the data is available. For every Oracle database, we will be having ONE or more data files associated. A data block is nothing but a logical space where the Oracle database data is stored. A data file is nothing but a file where all the data is available. For every Oracle database, we will be having one or more data files associated.

Answer»

A DATA block is nothing but a logical SPACE where the Oracle database data is stored.

A data FILE is nothing but a file where all the data is available. For every Oracle database, we will be having ONE or more data files associated.

A data block is nothing but a logical space where the Oracle database data is stored.

A data file is nothing but a file where all the data is available. For every Oracle database, we will be having one or more data files associated.

Discussion