EXTERNAL TABLE The Access Driver【每日一译】--20121130

When you create an external table, you specify its type. Each type of external table has
its own access driver that provides access parameters unique to that type of external
table. The access driver ensures that data from the data source is processed so that it

matches the definition of the external table.

当你创建一个外部表，你指定它的类型。每个外部表的类型拥有它自己的访问驱动，它提供了

唯一的访问参数对于外部表的类型。访问驱动器确保了从数据源的数据是被处理过以致于它满足

外部表的定义。

In the context of external tables, loading data refers to the act of reading data from an
external table and loading it into a table in the database. Unloading data refers to the
act of reading data from a table in the database and inserting it into an external table.
The default type for external tables is ORACLE_LOADER, which lets you read table data
from an external table and load it into a database. Oracle also provides the ORACLE_
DATAPUMP type, which lets you unload data (that is, read data from a table in the
database and insert it into an external table) and then reload it into an Oracle database.
The definition of an external table is kept separately from the description of the data in

the data source. This means that:

在外部表的环境里，导入数据涉及到的行为是读取外部表的数据并且导入到数据库的表。卸载

数据涉及的行为是读取数据库中的表数据并且插入到一个外部表。默认的外部表的类型是ORACLE_LOADER

它让你从外部表读取表的数据并且导入到数据库。ORACLE也提供ORACLE_DATAPUMP类型，它让你卸载

数据（也就是从一个库里的表读取数据并且插入到一个外部表）并且重新导入到数据库。在数据源中外部表的定

义与数据的描述是保持分开的，这也意味着：

■ The source file can contain more or fewer fields than there are columns in the

external table

The datatypes for fields in the data source can be different from the columns in the
external table

#源文件可以包含更多或者更少的字段比起外部表的字段

#在源数据的字段类型可以不同于外部表中的列。