File extensions

From Oracle FAQ

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

Contents 1 SQL*Plus files 2 PL/SQL files 3 Oracle database files 4 SQL*Loader files 5 SQL*Net files 6 Forms files 7 Reports files 8 Other files

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

Other files

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