DataPump Reports ORA-39021: Database compatibility version 19.X.0.0.0 is not supported
(Doc ID 2610939.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
After database upgrade to 19c, DataPump export stops working and reports:
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:
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 |