Skip to content
ORACLE DATABASE SUPPORT
  • Home
  • ORACLE
    • 10G
    • 11G
    • 12c
    • 18C
    • 19c
    • 21c
    • RMAN
    • ASM
    • DataPump
    • DATAGUARD
    • RAC
    • GOLDEN GATE
    • ORA -ERROR
  • Linux
  • COURSES
  • Android

What is the difference between tablespace and datafile?

What are the control file and datafile in Oracle?

November 15, 2021September 28, 2021 by Shripal
What is control file and datafile in Oracle?

What is control file and datafile in Oracle? In this article, we are going to learn what is control files and datafiles in Oracle. In the Oracle database environment, each and every database has its own separate control files. The control files also called binary files which record the physical structure of the oracle database. … Read more

Categories ORACLE Tags create datafile in oracle, data file and control file in oracle, how to check control file location in oracle, how to find datafile path in oracle 11g, how to read control file in oracle, oracle database control file example, oracle list datafiles in tablespace, oracle tablespace full, sysaux tablespace in oracle, types of files in oracle database, types of tablespace in oracle, users tablespace in oracle, What are the types of data files?, what is an instance of a database, what is an oracle instance vs oracle database, What is control file and datafile in Oracle?, what is control file in oracle, what is datafile in oracle, What is difference between table and tablespace?, What is Oracle database instance?, What is the difference between tablespace and datafile?, Where are data files stored in Oracle?, Where is the control file in Oracle?, Which mode control files are opened for the instance? 2 Comments

SUBSCRIBE

Recent Posts

  • HOW TO DOWN HIGH WATER MARK
  • Why do we use FAL_SERVER and FAL_CLIENT parameters in Oracle dataguard
  • How to upgrade ORACLE 11G to 19C
  • How to Identify OS PID from SID in Oracle Database
  • Change Archivelog mode and Destination In Oracle 19c

Categories

  • 10G (13)
  • 11G (17)
  • 12c (17)
  • 18C (11)
  • 19c (25)
  • Android (2)
  • ASM (10)
  • DATAGUARD (8)
  • DataPump (14)
  • INTERVIEW (1)
  • Java (2)
  • Linux (7)
  • MySQL (2)
  • ORA -ERROR (16)
  • ORACLE (136)
  • Oracle 21c (4)
  • PDF (1)
  • PL/SQL (1)
  • Putty (2)
  • RMAN (12)
  • SCRIPTS (7)
  • SQL (11)
  • TUNING (5)
  • WINDOWS (2)
  • ABOUT US
  • CONTACT US
  • TERMS AND CONDITIONS
© 2022 ORACLE DATABASE SUPPORT • Built with GeneratePress