My Oracle Support Banner

DataPump Reports ORA-39021: Database compatibility version 19.4.0.0.0 is not supported (Doc ID 2610939.1)

Last updated on NOVEMBER 18, 2019

Applies to:

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

Symptoms

After database upgrade to 19c, DataPump export stops working and reports:

expdp system/<PASSWORD> directory=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>.dmp schemas=<SCHEMA_NAME>

Export: Release 19.0.0.0.0 - Production on Thu Oct 17 10:27:50 2019
Version 19.4.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39021: Database compatibility version 19.4.0.0.0 is not supported.

 
A failure is seen also with DataPump API:

SQL> SET SERVEROUTPUT ON SIZE 1000000
DECLARE
l_dp_handle NUMBER;
l_last_job_state VARCHAR2(30) := 'UNDEFINED';
l_job_state VARCHAR2(30) := 'UNDEFINED';
l_sts KU$_STATUS;
BEGIN
l_dp_handle := DBMS_DATAPUMP.open( operation => 'EXPORT',job_mode => 'SCHEMA', job_name => '<JOB_NAME>');
DBMS_DATAPUMP.add_file(handle => l_dp_handle,filename => '<DUMP_NAME>.dmp',directory => '<DIRECTORY_NAME>');
DBMS_DATAPUMP.add_file(handle => l_dp_handle,filename => '<LOG_NAME>.log',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.start_job(l_dp_handle);
END;
/
SQL> 2 3 4 5 6 7 8 9 10 11 12 13
DECLARE
*
ERROR at line 1:
ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4929
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5180
ORA-06512: at line 8

 

Changes

After upgrade to 19c, compatible parameter is set to:

 

Cause

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
Symptoms
Changes
Cause
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.