Problem solve Get help with specific problems with your technologies, process and projects.

What does it mean to mount a file?

Somewhere on the Internet, I read that we can use text files as virtual tables (i.e., we can read/write data from/into the text file by mounting the file). What does "mounting a file" mean?
Starting in Oracle9i, you can reference a text file that is external to the database just as if it were a table in the database. This concept is called an external table. Basically, you create a table that will access the external text file. You can then issue SELECT statements against this external table. These external tables are READ ONLY. You cannot modify their contents.

For more information, please refer to the Oracle documentation on external tables. The docs give you a complete,...

step-by-step example on how to create an external table.

This was last published in December 2004

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.