Q

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 first published in December 2004

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close