After the metadata for an external table is created, you can query the external data
directly and in parallel, using SQL. As a result, the external table acts as a view, which
lets you run any SQL query against external data without loading the external data
hints and with the PARALLEL clause. Using parallelism on an external table allows for
concurrent access to the datafiles that comprise an external table. Whether a single file
is accessed concurrently is dependent upon the access driver implementation, and
directly and in parallel, using SQL. As a result, the external table acts as a view, which
lets you run any SQL query against external data without loading the external data
into the database.
在外部表的元数据创建后,你可查询外部表数据直接地和并发地,通过使用SQL。结果就是,
外部表的行为像视图,它可以让你运行任何的SQL查询外部表数据而不需要导入外部表数据到
数据库中。
hints and with the PARALLEL clause. Using parallelism on an external table allows for
concurrent access to the datafiles that comprise an external table. Whether a single file
is accessed concurrently is dependent upon the access driver implementation, and
attributes of the datafile(s) being accessed (for example, record formats).
并发访问外部表的并发度的批定使用标准并发HINT使用PARALLEL语句。使用并发机制在一
个外部表允许并发的访问组成外部表的数据文件。一个单独文件是否被并发访问它取决于访问
驱动的执行,和被访问的数据文件的属性(比如记录格式)。