Oracle Database Discussions

Hello

I'm trying to export a table in Data Pump and getting an error.

Here are my DBMS_DATAPUMP procedure:

 DECLARE
  EXPORT_JOB_NAME VARCHAR2(256) := 'EXPORT_JOB_09';
  DMP_FILE_NAME VARCHAR2(256)   := 'EXPORT_FILE_PART_%L.DMP';
  DIRECTORY_NAME VARCHAR2(256)  := 'DPUMP_DIR';
  LOG_FILE_NAME VARCHAR2(256)   := 'EXPORT_JOB._09.LOG';
  SCHEMA_NAME VARCHAR2(128)     := 'HR';
  TABLE_NAME VARCHAR2(128)      := 'EMPLOYEE';
  L_DP_HANDLE  NUMBER;
BEGIN
    L_DP_HANDLE := DBMS_DATAPUMP.OPEN(
    OPERATION   => 'EXPORT',
    JOB_MODE    => 'TABLE',
    REMOTE_LINK => NULL,
    JOB_NAME    => EXPORT_JOB_NAME,
    VERSION     => 'LATEST');
    
  DBMS_DATAPUMP.ADD_FILE(
    HANDLE    => L_DP_HANDLE,
    FILENAME  => DMP_FILE_NAME, 
    DIRECTORY => DIRECTORY_NAME,
    FILESIZE  => '16G');
    
  DBMS_DATAPUMP.ADD_FILE(
    HANDLE    => L_DP_HANDLE, 
    FILENAME  => LOG_FILE_NAME, 
    DIRECTORY => DIRECTORY_NAME, 
    FILETYPE  => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE);
    
  DBMS_DATAPUMP.METADATA_FILTER (
    HANDLE => L_DP_HANDLE,
    NAME   => 'SCHEMA_EXPR',
    VALUE  => '= '''||SCHEMA_NAME||''''); 
  
  DBMS_DATAPUMP.METADATA_FILTER ( 
    HANDLE => L_DP_HANDLE,
    NAME   => 'NAME_EXPR',
    VALUE  => '= '''||TABLE_NAME||'''');
    
  DBMS_DATAPUMP.SET_PARAMETER(HANDLE => L_DP_HANDLE, NAME => 'METRICS', VALUE => 1);
  
  DBMS_DATAPUMP.SET_PARAMETER(HANDLE => L_DP_HANDLE, NAME => 'ENCRYPTION', VALUE => 'ALL');    
  DBMS_DATAPUMP.SET_PARAMETER(HANDLE => L_DP_HANDLE, NAME => 'ENCRYPTION_MODE', VALUE => 'TRANSPARENT');    
  DBMS_DATAPUMP.SET_PARAMETER(HANDLE => L_DP_HANDLE, NAME => 'ENCRYPTION_ALGORITHM', VALUE => 'AES192');    
   
    DBMS_DATAPUMP.START_JOB(L_DP_HANDLE);
    DBMS_DATAPUMP.DETACH(L_DP_HANDLE);
END;						

HR.EMPLOYEE:

 CREATE TABLE HR.EMPLOYEE (
    first_name VARCHAR2(128),
    last_name VARCHAR2(128),
    empID NUMBER ENCRYPT NO SALT,
    salary NUMBER(6) ENCRYPT USING 'AES192');

In my Database wallet status:

select * from v$encryption_wallet;

When I'm trying to export the HR.EMPLOYEE table with above mention export procedure I'm getting an error in the export log and it says:

ora-39207: value aes192 is invalid for parameter encryption_algorithm

I'm trying to export data in AES192 encryption and failing the above error.

Please note, I've tried to use ENCRYPTION_ALGORITHM as AES128 , AES192 and AES256 in separate Data Pump export procedure for the same table, only AES256 is working rest of the ENCRYPTION_ALGORITHM (AES128 , AES192) is failing with the same error.

Can anybody please help me to understand why I'm not able to export the table in AES 128 or AES192 ENCRYPTION_ALGORITHM?

Thank You!