Tuesday, April 28, 2020

What is data files?

What is a data file in oracle?


In this article, we are going to discuss what is the use of data files in oracle and why they are so important.

Every data in the oracle database stores in the data file physically. TO access the data file in oracle database we should be adding the data file in a tablespace which is the logical representation for the data file. 


We can see the data file in the dba_data_files view or in V$datafile.




loading...
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

tutu etek

tutu etek : tutu etek

  • DBA_USER
    DBA_USERS DBA_USERS is a default view in oracle database which describes all users of the database. This view contains inf...
  • dba_data_files
    Dba_data_files Dba_data_files is a default view in Oracle database. This contains information about the data files in the data...
  • What is data files?
    What is a data file in oracle? In this article, we are going to discuss what is the use of data files in oracle and why they are so im...