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...