You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.
Which is the most effective method to access this data in your database?
A.
Use the SQL*Loader utility.
B.
Create an external table and leave the data in the flat file.
C.
Use the Oracle Data Pump utility.
D.
Use the database link.
Correct answer is B