C H A P T E R  14

images

External Tables

Sometimes DBAs and developers don’t grasp the utility of external tables. The Oracle external-table feature enables you to perform two distinct operations:

  • Directly select information from operating-system flat files via SQL, which allows you to do tasks such as loading operating-system comma-separated-value (CSV) files into the database.
  • Create platform-independent dump files that can be used to transfer data. You can also create these files as compressed and encrypt them for efficient and secure data transportation.

One common use of an external table is that it allows you to use SQL*Plus to select data from ...

Get Pro Oracle Database 11g Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.