In, the previous example a 10g data pump generated an External Table that was transparently read by the 11g release.
Let's create an 11g data pump External Table named DP_DEPARTMENTS
:
create table dp_departments organization external( type oracle_datapump default directory EXTTABDIR access parameters ( version '10.2.0' ) location ('dp_departments.dmp') ) as select * from departments Table created. SQL> select count(*) from dp_departments; COUNT(*) ---------- 27
In the previous example it is important to point out that the VERSION
keyword defines the compatibility format.
access parameters ( version '10.2.0' )
If this clause is not specified then an incompatibility error will be displayed.
SQL> select count(*) from dp_departments;
select count(*) from dp_departments
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-39142: incompatible version number 2.1 in dump file
"/home/oracle/external_table_dest/dp_departments.dmp"
ORA-06512...