What Is Flat File in Oracle

Flat files are stored within modules that enable you to group multiple flat files. To create a flat file module: Right-click the Files node in the Projects Navigator and select New Flat File Module. Oracle Warehouse Builder displays the Welcome page for the Create Module Wizard.

What is a flat file used for?

Flat files are a bare means of storing table data but do not hold relations between the tables within them. Programmers use flat file databases when building applications. Their simple structure means they take up less space than structured files.

What is flat file example?

Examples of flat files include /etc/passwd and /etc/group on Unix-like operating systems. Another example of a flat file is a name-and-address list with the fields Name, Address, and Phone Number. A list of names, addresses, and phone numbers written by hand on a sheet of paper is a flat-file database.