What are the different file extensions that are created by
Oracle ?

Answer Posted / chandan

SQL*Plus files
.sql - scripting language

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 - Redo Log
.arc - Archive log
SQL*Net files
.ora -
tnsnames.ora
sqlnet.ora
SQL*Loader files
.ctl - Control file
.dat - Data file
.bad - Bad file
.dsc - Discard file

Forms files
.fmb - Forms binary
.fmt - Forms text
.fmx - Forms executable
Reports files
.rdf
.rep
.rex

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are codd rules?

733


What is data model and types?

700


What is atomicity in dbms?

689


What is a field in database?

680


List few ways to code transactions in an efficient manner?

690


What is the importance of database in an organization?

618


What are the three levels of data abstraction?

786


How to monitor firebird server activity?

714


Define weak entity set.

819


What are the disadvantage in file processing system?

710


Where is database stored?

663


What is blob database?

654


How many number of columns can a RECORD GROUP have ?

1782


What is the meaning of flat file database?

686


Explain about cursors?

718