File extensions

From Oracle FAQ
Jump to: navigation, search

List of Oracle file extensions - only files with extensions listed below can be uploaded to the Forum.

SQL*Plus files[edit]

  • .sql - SQL script
  • .lst - spool file

PL/SQL files[edit]

  • .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[edit]

  • .dbf - database file
  • .log - Online Redo Log
  • .rdo - Online Redo Log
  • .arc - Archive log

SQL*Loader files[edit]

  • .ctl - Control file
  • .dat - Data file
  • .bad - Bad file
  • .dsc - Discard file

SQL*Net files[edit]

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

Forms files[edit]

  • .fmb - Forms binary
  • .fmt - Forms text
  • .fmx - Forms executable

Reports files[edit]

  • .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.

Other files[edit]

Other commonly used extensions:

  • .txt - text files
  • .pdf - Acrobat PDF files
  • .log - Log files
  • .csv - Comma Separated Values (CSV)
  • .gif - GIF Image file
  • .jpg - Jpeg Image file
  • .jpeg - Jpeg Image file
  • .png - PNG Image file
  • .bmp - Bitmap Image file
  • .xbm - X Bitmap Image file