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