My Oracle Support Banner

How to resolve Datapump Export issues with ORA-39214: Data Pump does not support external tables with encrypted columns using External Tables (Doc ID 2997673.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

Metadata Export of external table fails with encrypted columns. The error references "encrypted columns" but reviewing DDL for affected table confirms the columns are not encrypted

Testing with ENCRYPTION_PASSWORD and ENCRYPTION=ENCRYPTED_COLUMNS_ONLY arguments fail with the same issue

SQL> select tablespace_name from dba_tables where table_name='TEST';
SQL> select * from dba_encrypted_columns where table_name='TEST';

SQL> select tablesapce_name, encrypted from dba_tablespaces;

TABLESPACE_NAME   ENC
----------------------   ------
SYSTEM                    YES
SYSAUX                    YES
UNDOTBS1                YES
TEMP                        YES
USERS                      YES 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.