Pr.Pg Next Pg

Database files tutorials

  • Data within a database is stored on disk in one or more data files. Prior to being written to the data file(s), every transaction is written to a transaction log file.

  • The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).

  • The term database is correctly applied to the data and their supporting data structures, and not to the database management system (DBMS).

  • The database data collection with DBMS is called a database system.

  • The term database system implies that the data is managed to some level of quality (measured in terms of accuracy, availability, usability, and resilience) and this in turn often implies the use of a general-purpose database management system (DBMS)

 

File Extension of Database:

  • Following are list of Oracle file extensions :


SQL *Plus files:

  • .sql - SQL script

  • .lst – spool file


PL/SQL files:

  • .pls –PL/SQL source

  • .plb - PL/SQL binary

  • .pks - Package source or package specification

  • .pkb - Package binary or package body

  • .pck - Combined package specification plus body


Oracle database files:

  • .dbf- database file

  • .log- Online Redo Log

  • .rdo- Online Redo Log

  • .arc- Archive log


SQL *Loader files:

  • .ctl - Control file

  • .dat - Data file

  • .bad - Bad file

  • .dsc - Discard file


SQL *Net files :

  • .ora - tnsnames.ora, sqlnet.ora, etc.


Forms files:

  • .fmb – Forms binary

  • .fmt- Forms text

  • .fmx – Forms executable


Reports files:

  • .rdf - contains a single report definition in binary format. .RDF files are used to both run and edit reports.

  • .rep - contains a single report definition in binary format. .REP files are used solely to run reports; you cannot edit a .REP file

  • .rex - contains a single report definition in text format. .REX files are portable.


Pr.Pg border                                              Next Pg