First page Back Continue Last page Graphics

…External Tables…

Notes:

This example demonstrates the use of the ORACLE_DATAPUMP external table driver to export table data. The source for the CREATE TABLE ORGANIZATION EXTERNAL AS SELECT statement (see line number 8) is a normal heap table. The target is the dump files specified in the LOCATION parameter. Parallel processing is supported to increase performance; be sure to have at least as many dump files as DOP (degree of parallelization).
Refer to the supplied script external_table_datapump.sql for a copy of the code shown in this example.
Supplemental Notes
You can use DBMS_METADATA to generate a template of DDL required to create this table – using this dump file set – at another database:
LINUX> set long 2000
LINUX> select dbms_metadata.get_ddl('TABLE','WEBHITS_EXTERNAL') from dual;

Notes for this slide continue on the next page…